![]() |
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 |
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 |
All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com