Payroll formula helped needed to pay differential on Sat and Sunday

M

mrteater

New member
Joined
Aug 5, 2019
Messages
5
Reaction score
0
Points
0
Excel Version(s)
Office 365
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.View attachment Field Tracker Example.xlsx
 
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.
 
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)))​
 
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
 
You must log in or register to reply here.
Back
Top