AnsweredAssumed Answered

Calculating Hours between two Time questions

Question asked by ben_vk on Mar 25, 2020
Latest reply on Mar 29, 2020 by j.moore-esristaff



I am trying to wrap my head around calculating hours between two TIME fields. There are alot of blog posts around this, but none that I have found that give me hours worked in this format:


Start Time = 10am

Finish Time = 2.30pm

Calculation == 4.5


I have the below excel document, can someone please tell me how to get the result I am looking form? 


I know this is a simple one but I can't get it!


See row 12 & 13 below



I try doing ${time_end}-${time_start}/3600000 but I get this error:



Note: I know there is a reference error on line 13 in the screenshot, it has been resolved, it is unrelated to this question