Format time calculation with hours and minutes

4719
11
Jump to solution
11-09-2017 07:58 AM
BrianShepard
Occasional Contributor

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. 

Tags (3)
0 Kudos
11 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Khalil,

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

0 Kudos
ChrisRoberts2
Occasional Contributor III

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

0 Kudos