On Nov 14, 11:16*am, 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)

let A1 be the hours you worked and A2 be you pay rate.
assuming you get 1.5 your pay rate for over time
=IF(A140,(A1-40)*A2*1.5+40*A2,A1*A2)

this should do the trick