Not sure but matbe something like this
If you have 42 hours in cell A1
put this into cell B1 =IF(A1=40,40*14.9,A1*14.4)
put this into cell C1 =IF(A140,(A1-40)*22.35,0)

"Mandy" wrote:

I am making a pay calculator spreadsheet.
I am trying to figure out the formula that will help me to calculate overtime.

So if I have 41 hours listed then one cell will show with 40hrs and the
another cell will show if over 40 the amount.

So if I make 14.90hr and I have worked 42hrs.

A1 shows 40hrs at 596.00
A2 shows 2hrs at 44.70(22.35hr)