sum total of hours minutes seconds in excel 2003

S

Sherri Grezel

I have a large spreadsheet of hours minutes and seconds (00:00:00) and I want
a grand total. I can't seem to create a function that will grand total over
2000 cells of times. Most of the times listed are seconds. I want the grand
total to show the total hours minutes and seconds so I can further divide by
the number of work days in the month.
 
D

David Biddulph

Format the result as [h]:mm:ss to allow it to display greater than 24 hours.
 
Top