Summing Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.

Stephen Hogg said:
I have a query which allows an operator to enter an on and off time, I
Click to expand...
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.
 
Back
Top