Overtime and Regular Time sheet formula setup

We need time formulas set up to reflect we work 37 hours but get paid for 40. I need to be able to reflect this on the overtime side.

Total hours worked will be 37 even though we will be getting paid for 40.

If someone, works 39 hours, I need it to reflect as 2 hours of regular rate overtime
If someone, works 42 hours, i need it to reflect as 3 hours of regular rate overtime and 2 hours of 1.5 overtime.

I have a chart if anyone needs to see it. Thanks!

A1 (total hours)
B1 (regular overtime): =MIN(A1-37,40-37)
C1 (1.5 overtime): =MAX(A1-37-B1,0)

Thank you SO much for your help.
If I end up with a negative, any way to make the formula show a zero instead of a negative?

Originally Posted by masteff

A1 (total hours)
B1 (regular overtime): =MIN(A1-37,40-37)
C1 (1.5 overtime): =MAX(A1-37-B1,0)

Sorry, just back to the forum today to see the follow up question... nest a MIN/MAX

So B1: =MIN(MAX(A1-37,0),40-37)