G Guest Oct 29, 2005 #1 I need to write an excel formula that calculates hourly wages up to 30 hours and then time and a half after 30 hours in one formula.
I need to write an excel formula that calculates hourly wages up to 30 hours and then time and a half after 30 hours in one formula.
G Guest Oct 29, 2005 #2 If say the hourley wage if £15 and hour, and the hours are in cell a1 =IF(A1<=30,15*A1,22.5*A1) of course you could and should have the hourley rate in a cell
If say the hourley wage if £15 and hour, and the hours are in cell a1 =IF(A1<=30,15*A1,22.5*A1) of course you could and should have the hourley rate in a cell
S Sandy Mann Oct 29, 2005 #3 Naz said: If say the hourley wage if £15 and hour, and the hours are in cell a1 =IF(A1<=30,15*A1,22.5*A1) Click to expand... That would pay ALL hours at the overtime rate if the employee worked more than 30 hours Try: =MIN(A1,30)*15+MAX(A1-30,0)*22.5 -- HTH Sandy (e-mail address removed) Replace@mailinator with @tiscali.co.uk
Naz said: If say the hourley wage if £15 and hour, and the hours are in cell a1 =IF(A1<=30,15*A1,22.5*A1) Click to expand... That would pay ALL hours at the overtime rate if the employee worked more than 30 hours Try: =MIN(A1,30)*15+MAX(A1-30,0)*22.5 -- HTH Sandy (e-mail address removed) Replace@mailinator with @tiscali.co.uk
G Guest Oct 29, 2005 #4 And the problem with that would be?? ;-) I apologise for the oversight the formula should of course read =IF(A1<=30,15*A1,30*15+((A1-30)*22.5))
And the problem with that would be?? ;-) I apologise for the oversight the formula should of course read =IF(A1<=30,15*A1,30*15+((A1-30)*22.5))
