LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum hours minutes seconds excel 2003 Sherri Grezel Excel Worksheet Functions 1 April 22nd 08 05:02 PM
Display hours, minutes, seconds on a time-scale axis in Excel 2003 Saritha Charts and Charting in Excel 3 April 1st 08 11:16 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
Sum minutes and seconds to total hours deck4 Excel Discussion (Misc queries) 3 August 29th 05 02:34 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"