Results 1 to 8 of 8

Thread: Payroll formula helped needed to pay differential on Sat and Sunday

  1. #1
    Seeker mrteater's Avatar
    Join Date
    Aug 2019
    Posts
    5
    Articles
    0
    Excel Version
    Office 365

    Payroll formula helped needed to pay differential on Sat and Sunday



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

    I need help on the formula so that it will identify based off of the date so it pay $1 extra per hours worked on Saturday and time and a half for hours worked on Sunday. See the attached sheet. The pay rate is in column C. The date are in row 2 with the daily pay totals are in columns starting with E then G then I... I need help with updating the formula if possible or another idea to make this happen.Field Tracker Example.xlsx

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,235
    Articles
    0
    Excel Version
    Office 365 Subscription
    This request has been cross-posted on at least one other forum. The rules require you to proved a link or links to those cross-posts, please.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker mrteater's Avatar
    Join Date
    Aug 2019
    Posts
    5
    Articles
    0
    Excel Version
    Office 365
    Sorry never heared of this but Here is the cross-post link https://www.excelforum.com/excel-for...ml#post5170405

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,235
    Articles
    0
    Excel Version
    Office 365 Subscription
    It’s in this forum and Excel Forum’s rules.

    Here is this forum’s take on it: https://www.excelguru.ca/forums/faq....osting_details
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker mrteater's Avatar
    Join Date
    Aug 2019
    Posts
    5
    Articles
    0
    Excel Version
    Office 365
    Sorry once again--I have posted the cross post link on both platforms. I cannot find where I am able to edit the original post so I'm adding it in a reply.

    Here is the cross-post link
    https://www.excelforum.com/excel-for...ml#post5170405

  6. #6
    Seeker mrteater's Avatar
    Join Date
    Aug 2019
    Posts
    5
    Articles
    0
    Excel Version
    Office 365
    This is resolved now-- thanks to the Excel Forum team--
    =IF(WEEKDAY(D$2)=1,IF(D3>480,(D3-480)/60*$C3*3+480/60*$C3*1.5,D3/60*($C3*1.5)),IF(WEEKDAY(D$2)=7,IF(D3>480,(D3-480)/60*($C3+1)*1.5+($C3+1)*480/60,D3/60*($C3+1)),IF( D3 > 480, ((D3-480)/ 60*$C3*1.5) + ($C3 * 480/60 ), $C3*D3/60)))

  7. #7
    Seeker mrteater's Avatar
    Join Date
    Aug 2019
    Posts
    5
    Articles
    0
    Excel Version
    Office 365
    Yes I get it AliGW-- Can you stop beating a dead horse. I have read the rules since my agredious violation. I posted the links as requested. Can you ever see it in your self to let it go. Not sure why you keep posting the same comment of how awful I was to violate the cross-post forum rule. No one even tried to assist with my actual formula question. I already have my answer and do not need further assistance. Case closed

  8. #8
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,235
    Articles
    0
    Excel Version
    Office 365 Subscription
    Sorry - the second post was in error. I shall remove it.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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