Calculating time over 24 hrs
Posted on 2012-03-16
I have a program that keeps how many hours worked at a store. I have 2 text boxes one for Enroute to strore (named:Time Arrived1) and Time Completed (Time Departed2). I can get the correct time if it isnt over 24 hrs. example: 2200-2350 = 3.83 but if it is 2334-0119 i get -22.25. When it should be 1.75. I take total time /60. Then text field that holds this value has a control source of =DateDiff("n",[time departed1],[time arrived2])/60.
Any help would be greatly apprectiated. Also I have tried =DateDiff("n",[time departed1]-1-[time arrived2])/60 and it doesnt work. Also the time fields are written in the db as time only. The field is set for time/date and the text field is set for short time.
Thanks in advance!!