| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum hours minutes seconds excel 2003
I am trying to tally up a large spread sheet of hours seconds and minutes and
then I want to divide the total hours seconds minutes by the number of work days for a particular month |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum hours minutes seconds excel 2003
Just divide. Assume the total time is in B2 and the number of workdays are
23 =B2/23 If you need to do further calculations with rates you need to multiply any time total with 24 and then multiply the rate per hour -- Regards, Peo Sjoblom "Sherri Grezel" <Sherri wrote in message ... I am trying to tally up a large spread sheet of hours seconds and minutes and then I want to divide the total hours seconds minutes by the number of work days for a particular month |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display hours, minutes, seconds on a time-scale axis in Excel 2003 | Charts and Charting in Excel | |||
| Converting hours, minutes, seconds, to hours | Excel Worksheet Functions | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Linear Mode
