|
|
|
|
|
|
Overtime Pay
Calculating overtime pay for employees in Excel
|
Q: |
I have a simple employee time sheet showing how
many hours each employee has worked this week. How can I calculate
the correct amount to pay them if I have to figure in overtime pay?
If the employee works up to 40 hours, they get their normal pay
rate. From 40 to 50 hours is time-and-a-half, and over 50 hours is
double-time. |
|
|
|
|
A: |
You can use some simple
calculations and
IF functions to figure this out. For example,
in the sheet below, to calculate how many "normal" hours (40 and
under) you can say:
|
|
|
=IF(I2<=40,I2,40)
 |
|
|
|
|
|
Here is a FREE video tutorial that shows you how to set
this sheet up step-by-step:
|
By Richard Rost
Click here to sign up for more FREE tips
|
