I'm a salaried employee, ?how to calculate actual rate of pay

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top