Assiming your first hours worked (33) is in A2 - put this in C2:

=MIN(A2,40)*B2

This chooses the smaller of the hours worked and 40, so it does away
with the need for an IF. Put this in D2 to evaluate the overtime:

=IF(A240,(A2-40)*B2*1.5,0)

or:

=MAX(0,A2-40)*B2*1.5

to avoid using IFs.

Hope this helps.

Pete


On Jul 25, 1:16*pm, new to excel <new to
wrote:
*Total Hours Worked * * Wage/Hour * * * Regular Pay * * Overtime * * * *Gross Pay

33 * * * $38.00 * * * * *$1,254.00 * * * * * * *
40 * * * $29.00 * * * * *$1,160.00 * * * $- * *
46 * * * $9.50 * $437.00 * * * * * * * *
46.5 * * $28.75 * * * * *$1,336.88 * * * * * * *
40 * * * $7.50 * $300.00 * * * * $- * *

Can someone show me the IF *that calculates the regular pay and the over
time pay at 1.5 over 40 hours

Thanks