sum total of hours minutes seconds in excel 2003
 

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.

sum total of hours minutes seconds in excel 2003
 

Just sum directly:

=SUM(A1:A2000)


--
Gary''s Student - gsnu200781


"Sherri Grezel" wrote:

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.

sum total of hours minutes seconds in excel 2003
 

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

"Sherri Grezel" wrote in message
...
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.