Time Sheet - Reg Hrs & OT

[cheri]

Hi,

I am currently setting up a weekly time sheet (Mon - Sun) and cannot
figure out how to calculate the daily hours worked by seperating them
out based on regular hrs & OT.

I have a cell for Start, Lunch Out, Lunch In, End of Shift & PTO.

My first calculation needs to show how many hrs did the employee work
before lunch, and then after lunch and if they used PTO this needs to
be included.

My next calculation needs to show how many hrs did the employee work
for the date but not exceeding 8 hrs.

The final calculation needs to show the OT, if any, that was worked per
shift. OT begins after an 8 hr shift. If none, then the cell should
show zero.

Could you pls help me with the proper forumula?

Thank you so much,
Cheri

 

[Jason Morin]

MVP Chip Pearson has a nice timesheet example with an
explanation of formulas that may help you:

http://www.cpearson.com/excel/overtime.htm

HTH
Jason
Atlanta, GA

 

[Squid]

Check out Chip Pearson's website. (he is tha man!)
http://www.cpearson.com/excel/overtime.htm