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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

advanced 'if' multiply 2
Formula to sum based on a change in another column 2
Time Tracking & Reports 1
How do I calculation vacation accrual? 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Calculating % 2
Employee Time Database with "Banked Time" 3

Top