Overtime/Doubletime for Saturday & Sundays
 

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(Q118,8,Q11)
Overtime: =IF(Q1112,4,IF(Q118,Q11-8,0))
Doubletime: =IF(Q1112,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(S1640,+Q16-T16,IF(Q168,8,Q16))
Overtime: =IF(S1640,IF(Q1612,4+T16-4-Q16+12,+T16),0)
Doubletime: ==IF(Q1612,Q16-12,0)

Can send sample of timesheet upon request.

Brian
--
Life is tough, but it''s tougher when you''re stupid.
- JohnWayne

Overtime/Doubletime for Saturday & Sundays
 

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
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24267