I've searched this forum and followed all the prior advise and it does not seem to be working. I have a very simple problem that I can't figure out.

I am working on tracking my time for clients. I have a StartTime a StopTime and and ElapsedTime Field. The StartTime and StopTime fields are set up as TIME fields, and the ElapsedTime field is a calculation of Stoptime-StartTime/60.

I can't get it to work. Currently, with 8:00 in StartTime and 9:00 in Stoptime, I get "31920" in the ElapsedTime field if it is set to number and I get 8:52:00 if it is set to time. I've tried every combination that I can come up with without success.

I've tried dividing by 60 and 360 and I cannot even get close.

Any help would be appreciated.

If you want the result as time, then set the result type to Time and make the calculation =

StopTime - StartTime

If you want something else, please clarify.

--

P.S. The reason you're getting such weird results is evaluation order: division comes before subtraction. To get the number of elapsed minutes, you need to do +

( StopTime - StartTime ) / 60