Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 38 of 38

Thread: Formula for tracking my hours worked including overtime etc

  1. #31


    Register for a FREE account, and/
    or Log in to avoid these ads!

    so with the 8,8,8,8,8,10.
    The 8's would all be just regular time. The 10 on the FRI would be the first 4 hours as regular then the rest would be Overtime. Because now the 44 hour rule for the week kicks in
    Last edited by chichirod; 2015-03-31 at 04:12 AM.

  2. #32
    The 12,8,8,8,6.
    So the first shift (12) would be 10 reg and 2 OT. All 3 of the (8) would be regular and the (6) would also be regular. Since the 12 hour shift was over the 10 hour rule the OT would kick in. With the 8 and 6 hour shifts none were over the 10 hour rule and did not surpass the 44 hours for the week so none of them would qualify for OT
    Last edited by chichirod; 2015-03-31 at 04:13 AM.

  3. #33
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    So are you saying that the rule you stated at the beginning that Fri and Sat is all OT does not really apply?

    I have to ask, if they do a week of 10,8,8,8,8,0,0 why would they get 2 hours OT on Sun when they fail to do 44 hours in the week?

  4. #34
    Sorry I did a poor job of explaining the FRI, SAT thing. My example was showing what a full week of hours would look like.

    With the 10,8,8,8,8,0,0 scenario none of that would be OT. Because none of it went over 10 hours and it never met the 44 hour rule for the week.

    I'm not sure where in here that I said it did.

    Had that scenario looked like this 12,8,8,8,8,0,0 then the first shift (SUN) there would have been 10 regular hours and 2 OT hours and the rest of the week would have still just been regular hours because the 44 hour rule never kicks in.

    Well it just actually gets to the 44 hours so had there been any hours in one of those "0" positions then that would have been straight OT
    Last edited by chichirod; 2015-03-31 at 12:39 PM.

  5. #35
    Sorry my last line in my last statement is NOT correct (Well it just actually gets to the 44 hours so had there been any hours in one of those "0" positions then that would have been straight OT). Because out of that first 12 hour shift only 10 of them would have counted towards the 44 hours for the week.

  6. #36
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    My Final attempt

    SUN row : =MIN(($C1-$B1)*24,10)
    MON-SAT rows: =IF(OR($A2="FRI",$A2="SAT"),MIN(44-SUM($D$1:$D1),($C2-$B2)*24),IF($A2="THU",MIN(44-SUM($D$1:$D1),($C2-$B2)*24),MIN(10,($C2-$B2)*24)))

    Remember to adjust the SUM values if using in rows other than 1-7.

  7. #37
    It looked like it was working until i put no hours in for Sunday as if I didn't work it. I have all of the days as 14 hour shifts. So what it did was changed the Thursday shift to 14 regular hours and no OT instead of making it a 10 reg and 4 OT and then making Friday 4 OT and 10 reg. I do really thank you for trying. I know you put way more work into this than you had to. Thank you

  8. #38
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,673
    Articles
    0
    Excel Version
    2010 on Xubuntu

Page 4 of 4 FirstFirst ... 2 3 4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •