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
in a column? I am using =sum([totaltime]). What am I doing wrong.
Floyd
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
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
(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