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

1. 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. 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.

3. Sorry never heared of this but Here is the cross-post link https://www.excelforum.com/excel-for...ml#post5170405

4. 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

5. 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. 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. 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. Sorry - the second post was in error. I shall remove it.

Posting Permissions

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