Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overtime Calculation for Overtime | Excel Worksheet Functions | |||
how to change week-offs from saturday and sundays to sunday and mo | Excel Discussion (Misc queries) | |||
OVERTIME AND DOUBLETIME | Excel Worksheet Functions | |||
=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 | Excel Worksheet Functions | |||
No Sat & Sundays | Excel Discussion (Misc queries) |