time format on report

  • Thread starter Thread starter BigFoot Dereki
  • Start date Start date
B

BigFoot Dereki

i have made a query that sum a field that is date/time with time durations
(e.g 00:12:02). the total sum is over 24h, when i create a report instead of
showing me eg. 25:12:12 it shows only how many hours is over 24, in excel
thare is a custom format (H):mm:ss that outputs the sum over 24, i have
tried to format the filed in access but no luck.
i hope someone has an answer
thanks in advance
 
The Time formats will not show more than 24 hours.

You could get the number of seconds with:
=DateDiff("s", #0:00:00#, [MyField])
and then use integer division (\) and Mod to divide by 60 and get the
minutes, and again for hours.

Alternatively, if you just need a display value (not something you can do
calculations with) try calculating the whole hours and concatenating the
minutes and seconds:
=DateDiff("h", #0:00:00#, [MyField]) & Format([MyField], "\:nn\:ss")
 
Back
Top