Overtime/Doubletime for Saturday & Sundays

[Brian C]

OK, I can get overtime and doubletime figured out for Mon-Fri it's
Rows:
Monday 11's
Tuesday 12's
Wednesday 13's
Thursday 14's
Friday 15's
Saturday 16's
Sunday 17's
Colomns:
Total Hours; =ROUND((+F11-E11+D11-C11)*24,2)
Regular Hours:=IF(Q11>8,8,Q11)
Overtime: =IF(Q11>12,4,IF(Q11>8,Q11-8,0))
Doubletime: =IF(Q11>12,Q11-12,0)
where C is 1st start, D is 1st end, E is 2nd start, F is 2nd end; G is
Rugular hours; Q is Total Hours, I is Overtime; J is Double time; K-M is
Administrative entries like PTO, Holiday, Sick & Other; R is Cummulative
(G+K+L+M); S is bucket for 40 hours for Saturday.

The problem comes in on Saturday & Sunday. Sunday is supposed to be
Doubletime (company policy) and Saturday is overtime if you worked atleast 40
Mon-Fri, or used Holiday/PTO/Sick/Other, otherwise see Mon-Fri.

After twiddling for days now I can on get the Saturday row to work with
40hours. I wouls like to have it cover <40 hours as well. Is it possible?
Saturdays formulas todate;

Total Hours; =ROUND((+F16-E16+D16-C16)*24,2)
Regular Hours: =IF(S16>40,+Q16-T16,IF(Q16>8,8,Q16))
Overtime: =IF(S16>40,IF(Q16>12,4+T16-4-Q16+12,+T16),0)
Doubletime: ==IF(Q16>12,Q16-12,0)

Can send sample of timesheet upon request.

Brian

 

[The Code Cage Team]

Brian, feel free to join our forums where you can upload a workbook, you
may consider posting your question with workbook in 'Worksheet Functions
- The Code Cage Forums'
(http://www.thecodecage.com/forumz/worksheet-functions)


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com