I need help with a formula...if it's possible.
I need to determine hourly rate of pay based on the following known variables:
Daily pay rate
Number of regular hours
Number of OT hours.
My formula needs to calculate hourly rate of pay.
For example:
John gets paid $130/day. This week he worked 5 days. Total pay is $650.
He worked 40 hours on regular pay and 15 hours of overtime pay.
Based on the fact that overtime is 1.5 times the regular hourly pay how do I calculate the hourly pay using an excel formula?
HELP!
Bookmarks