I want to calculate an hourly gross pay, based on pay up to 80 hours, then if hours are >80, use the overtime pay rate of 1.5 times the base amount [closed]

I’m building a budget on my spreadsheet. I currently have 90 hours on my check.

Hours Input to Paycheck Output – Sheet 1

Consider Hours the INPUT
And Paycheck my OUTPUT

I want to use the following table:

Hourly Table and Pay Rate – Sheet 2

Please note: 0-80 Pay Rate of 23.88 is my cell D4

80-100 pay rate of 35.82 is D5

100 pay rate of 47.76 is D6

So if I input 90 in my HOURS field, I want the PAYCHECK to calculate to something like =(80Sheet2!D5)+(10Sheet2!D6)

But I want it to do the math for 80 and 10 hours separately.