Formula for time sheet

[jacq]

Hello,

Desperate for some help please I've been able to create a time sheet, which gives me the overtime worked. My problem is in creating a formula that shows the reulst f the overtime worked is <= 3 hours, I need to multiple the normal rate x 1.5. And if the overtime worked is >=4, i need to multiple the normal rate x 2.

So hypothetically, I know that if someone does 5 hours overtime, the first 3 hours are at 1.5, and the remaining 2 hours are at 2.0 - but I don't know how to put this in excel language!

Thanks in advance for your help

Jacq

[teylyn]

Hello, please edit your thread title and take the drama out.

What rate applies if the overtime is between 3 and 4 hours? Let's just assume you meant <=3 and >3 above.

If the overtime worked is in cell A1, and normal rate is in B1 you could use something along the lines of:

=if(A1>3,(B1*1.5*3)+(B1*2*(A1-3)),B1*1.5*A1)