Summing Time

[Guest]

I have a query which allows an operator to enter an on and off time, I then calculate the duration. I then run a report which sums these time durations, the result is ok as long as the figure doesn't exceed 24 hours, if it does it returns an incorrect value. Is there an easy way to sum these times.

 

[Allen Browne]

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.

I have a query which allows an operator to enter an on and off time, I

then calculate the duration. I then run a report which sums these time
durations, the result is ok as long as the figure doesn't exceed 24 hours,
if it does it returns an incorrect value. Is there an easy way to sum these
times.