topic Time Difference to decimal in ArcGIS Pro Questions

Time Difference to decimal

ModernElectric — Wed, 09 Oct 2024 20:52:20 GMT

I am working with a File GDB Feature Class thru Field Calculate (Python or Arcade) and trying to figure out HOW to calculate the difference between the Start Time and End Time.

Example:

Start Time: 7:00 AM

End Time: 2:15 PM

Time Difference: 2.25

How do I go about doing this? My other research results in just a flat hour or minutes and cannot figure out how to convert to the actual decimal difference.

Thank You

Re: Time Difference to decimal

DavidSolari — Thu, 10 Oct 2024 15:54:38 GMT

If you have proper date fields in your data, they'll be converted into Python datetime objects when you run Calculate Field in Python3 mode. This means you can put something like this in your code block to get a decimal result:

def run(start, end): diff = end - start # creates datetime.TimeDelta object return diff.hours + (diff.minutes / 60.0)

Exercise for the reader: handle cases with null inputs.