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!