Select to view content in your preferred language

Format time calculation with hours and minutes

6607
12
Jump to solution
11-09-2017 07:58 AM
bshepard
Regular 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
12 Replies
khalilramadeen
Occasional Contributor

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

0 Kudos
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
Frequent Contributor

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