employee schedule

[jhendu]

I am trying to create an employee schedule Mon-Sun...I want to have a sum total of each employees hours worked...But I need it to sum the hours from time....How do I do that

thanks


J

 

[Jaafar Tribak]

Hi J,

If I understand yo correctly you wil have to format the cell that houses the Sum of the Hours with the following Time Format:

[h]:mm:ss

 

[ehs]

Hi,
I use a formula to calculate overtime hours, but it can also be used to collect regular hours. Format the "From" and "To" columns as time", and the formula cell in general or number. I use the 24 hour clock. Note that the formula includes the addition of one day (+1) just in case the start time is less than the finish time.(shift work) The "24" is used to convert the minutes to decimal, ie 4.5 hours, not 4:30 so you can add them up. The first "IF" just leaves the cell blank if the time is not entered.Then make a running total, and format the total as mentioned in the previous reply.

=IF(B2="","",24*(IF(B2<A2,B2+1-A2,B2-A2)))

I can provide an Excel sheet of what I use upon request.

I got this from Pearson's site originally. Take a look at
http://www.cpearson.com/excel/datearith.htm

ehs