Hello all,
I am presently making up a timesheet in excel which calculates the days wages (including time and a half & double time if possible)
I'll get to the point:
=IF(I88=0,"",IF(I88<=7,I88*$Z$80,IF(I88<=10,I88-7)*$Z$83+7*$Z$80)))
I88 is the cell which contains the days hours in total. A Standard Day is 7.5 hours long (excluding 30 minutes for lunch of course). Cell's Z80 and Z83 refer to 1x and 1.5x respectively. Cell 2x is 'Z88'...
The first 7 hours are worth 1x ($21.68)
After this it goes into 1.5x ($32.52)
After 10 hours it goes to 2x ($43.36)
As can be seen the formula works beautifully up until 10 hours, but then I can't figure out how to incorporate 2x after that...
I'm sure the answer is right in front of me, but at this point in time, I feel very frustrated with it... it escapes me!
Can anyone help me?
Thank you!
__________________________
Thank you all. I found the solution:
=IF(I88<7,I88*Z80,IF(I88<10,((I88-7)*Z83)+(7*Z80),((I88-10)*Z88)+(3*Z83)+(7*Z80)))
Where I88 is the hours. Z80 = normal rate. Z83 = Time and a half. Z88 = Double time!
I am presently making up a timesheet in excel which calculates the days wages (including time and a half & double time if possible)
I'll get to the point:
=IF(I88=0,"",IF(I88<=7,I88*$Z$80,IF(I88<=10,I88-7)*$Z$83+7*$Z$80)))
I88 is the cell which contains the days hours in total. A Standard Day is 7.5 hours long (excluding 30 minutes for lunch of course). Cell's Z80 and Z83 refer to 1x and 1.5x respectively. Cell 2x is 'Z88'...
The first 7 hours are worth 1x ($21.68)
After this it goes into 1.5x ($32.52)
After 10 hours it goes to 2x ($43.36)
As can be seen the formula works beautifully up until 10 hours, but then I can't figure out how to incorporate 2x after that...
I'm sure the answer is right in front of me, but at this point in time, I feel very frustrated with it... it escapes me!
Can anyone help me?
Thank you!
__________________________
Thank you all. I found the solution:
=IF(I88<7,I88*Z80,IF(I88<10,((I88-7)*Z83)+(7*Z80),((I88-10)*Z88)+(3*Z83)+(7*Z80)))
Where I88 is the hours. Z80 = normal rate. Z83 = Time and a half. Z88 = Double time!
Last edited: