Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum hours minutes seconds excel 2003 | Excel Worksheet Functions | |||
Display hours, minutes, seconds on a time-scale axis in Excel 2003 | Charts and Charting in Excel | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |