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.
Hello James Tedrick
Is it possible to calculate the hours and minutes for more than 24 hours. I tried the excel sheet you've attached here, but when fill for example (2:47 PM as start and 12:32 AM as end) this will give a minus value. I wanted to know if it's possible to get values more than 24 like 50:45 as summation.
Thanks in advance,
Khalil
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