Time format

[Kitty]

i'm calculating the staff total OT time, however, i found Access cant
display right when the time over 24 hrs, (i.e. when the sum is 25 hrs, it
display "01:00:00 (hh:nn:ss)" only)

and i try to use the format [hh]:mm:ss, which in Excel can display the right
time "25:00:00 (hh:mm:ss)"

can anyone tell me how can i display 25:00:00 in Access?? thanks in advance.

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://members.iinet.net.au/~allenbrowne/casu-13.html

The article explains how to use DateDiff() to get the difference in minutes,
and then format the result in hours and minutes using integer division and
Mod.