This is due to the way Access stores dates and times. Internally, it uses a
floating point number, where the integer part represents the date, and the
fractional part represents the time (half a day is .5, 6am is .25, and so
on).
That means that after sum sum time values over 24, it becomes another date,
with the remainder as the left-over time. The solution is to sum the number
of minutes rather than the time values, and then display the result as time.
For details on how to do that, see:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
moon the loon said:
i have a report that shows times in the format hh:mm. when i try to total
the times at the bottom of the report i have a problem when it goes over 24
hours... (eg 24hours 10minutes displays as 00:10) how can i stop this. i
know in excel that you have to put the hh in square brackets but that
doesn't work in access...................... help!!!
