G
Guest
If A1 has the number of hours you worked, and B1 has your hourly rate, and a
standard workweek is 40 hours, and OT = 1.5 times your hourly rate, then:
=IF(A1<=40,A1*B1,(A1-40)*B1*1.5+(A1*B1)).
Dave
standard workweek is 40 hours, and OT = 1.5 times your hourly rate, then:
=IF(A1<=40,A1*B1,(A1-40)*B1*1.5+(A1*B1)).
Dave