Calculating ovetime

[anglou]

I have the days of the weeks in columns b-h, column i I have “all hours” column J I have “regular” and column K I have “overtime”.
I am trying to take anything up to 40 hours and have calculate it in the regular column and in the overtime column I want anything over 40 hours. Is there a way to do that?


WEEKLY TIME SHEET
PAY WEEK DATE 2/6/15 to 2/19/15 #2 Week
EMPLOYEE FRI SAT SUN MON TUE WED Thurs All Hours Regular OT Vac
13 14 15 16 17 18 19
8.00 2.00 2.00 8.00 8.00 8.00 8.00 44.00
8.00 3.00 8.00 19.00 19.00 (40.00)
9.00 10.00 10.00 10.00 10.00 10.00 10.00 69.00 40.00 29.00
sck/ci 8.00 8.00
6.50 9.00 15.50


I got it work for someone working over 40 hours but can't see make if work for someone who works under 40 hours

[JeteMc]

If I am understanding correctly (see attached file) then the formulas that you want would be: (I2 for total hours)

Please Login or Register  to view this content.

(J2 for regular hours)

Please Login or Register  to view this content.

(K2 for overtime hours)

Please Login or Register  to view this content.

Calc OT.xlsx

Let me know if you have any questions.

[anglou]

Yes that works thank you for all your help.

[JeteMc]

Glad it worked. Please use the thread tools above your first post to mark the thread 'Solved'. Hope that you have a good day.