Format time calculation with hours and minutes

[bshepard]

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. 

[khalilramadeen]

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

[JamesTedrick]

Hi Khalil,

You would need to use datetime question to get the appropriate value, they should automatically account for the extra days.

[ChrisRoberts2]

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