Is there an easy way to calculate a duration from start to end displayed in hours and minutes? I've only seen mention of either/or. I've tried a few things unsuccessfully. Essentially I just want ${EndTime} - ${StartTime} in a h:mm format. So, if I have StartTime = 12:00PM and EndTime = 2:06PM, I want Duration to be 2:06, not 2.1 hours or 126 minutes.
Solved! Go to Solution.
Hi Khalil,
You would need to use datetime question to get the appropriate value, they should automatically account for the extra days.
This was just what I was looking for! Thanks James!
Just one question how do I get it to calculate part hours eg 1.5? this just seems to give the answer in whole hours