Hi, I am having trouble finding a formula to incorporate both the hourly rate and overtime rate weekly.

I am trying to create a formula that multiplies the "hourly rate X total hours weekly" IF the total hours are less than 44 hours.

But, if the total hours are greater than 44 hours, then every hour after 44 should be multiplied by the overtime rate only.

I am struggling to find a formula that incorporates these elements.



I have a column for Overtime hours worked, which doesn't mean these hours are paid by the overtime rate, because by the end of the week, the total could still be under 44 hours.

If someone could provide insight on this, it would be greatly appreciated.