Little different:
A1: 42 .... Total Hours worked
A2: =MAX(A1,40)*rate .... This is your gross income for regular hours
B2: =MAX(A1-40,0)*rate*1.5 .... This is your gross income for OT hours
--
** John C **

"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)