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