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

Hey, 

 

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

Outcomes