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
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.