ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum hours minutes seconds excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/184695-sum-hours-minutes-seconds-excel-2003-a.html)

Sherri Grezel

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

Peo Sjoblom

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