Time difference

[cfrankling]

Hello,



Im trying to calculate time difference between StartTime and EndTime, if both times are within the 24hr period, I have no issues coming up with the difference by just subtracting, the issues comes when the EndTime happens to be the next day, for example:

StartTime 22:00 Endtime 01:00 (next day)

I've tried the following code in a "text box control source" that I found on the net but in my particular case I end up with a neg time.

=DateDiff("n",[CheckInTime],[DispatchedTime])\60 & Format(DateDiff("n",[CheckInTime],[DispatchedTime]) Mod 60,"\:00")

Any suggestions would be greatly appreciated.

Thanks
Carlos

[CJ_London]

Assuming your time is just time and does not include a date in the underlying data then try


endtime+abs(endtime<starttime) - starttime

[cfrankling]

CJ_London, I owe you a beer, your suggestion works perfect.

Thank you!