Calculating the sum of hours and minuites.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Is there a way to sum the total number of hours and minutes e.g. 8:20
in a column? I am using =sum([totaltime]). What am I doing wrong.

Floyd
 
If you sum a date/time field, you end up with a date and time after day zero
(Dec 30, 1899).

It is generally better to store the time as a number of minutes. If
necessary, you can convert your time to minutes, sum it, and then display
the result as hours and minutes.

More info:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html
 
Back
Top