I am working on spreadsheets to determine regular hours (8 hours or less), overtime hours (8-12 hours), and double time hours (12+ hours).

I am having trouble figuring out how to calculate the overtime hours without either getting a negative number when the hours are less than 8, or causing it to calculate all hours over 8, including hours over 12, which should actually be double time.

Basically I am looking for a formula that would state: If the hours worked are more than 8 but less than 12, the result is regular pay rate*1.5, and if the hours worked are less than 8, the result is 0.

Any help would be greatly appreciated!

Note: I already have the hours worked as a number, so I don't need to multiply anything by 24 (as I know sometimes that is part of a formula to ensure the correct amounts).

Thanks!

## Bookmarks