Time Elapsed

[jb2606]

I am trying to build a form to calculate time elapsed/time difference.
Example if one turns up for work at 1900hrs (start) and ends his duty at 0200hrs the next day (end), how much time has elapsed? I am trying to use this argument :
Elapsed: IIf([end] > [start], Format([end] - [start], "Short Time"), Format(1 - [start] + [end], "Short Time"))
Unfortunately, I am not grtting the desired result. Could anyone please assist?
Thanks

 

[pbaldy]

Try:

Elapsed: Format([StartTime] -1 -[EndTime], "Short Time")

should work for both.

 

[jb2606]

Thanks it worked