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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum hours minutes seconds excel 2003 1
Calulating hours, minutes and seconds 5
How do I convert hours, minutes, and seconds into decimal format? 2
Adding Hours & Minutes 3
How to ignore a column of numbers in Grand Total for rows 1
Hours and sum of hours 2
Summing minutes and seconds 2
How do I enter accumulated time as hours, minutes and seconds? 1

Top