A one-week worksheet for employees who work some hours on a shift with extra pay. It totals straight-time pay at the base and differential rates, works out the weighted regular rate and adds the overtime premium for hours over 40 — the method federal law requires when a shift differential is paid.
What’s in the template
- Differential as a flat amount per hour or a percentage of the base rate
- Base-rate and differential hours for each day of the workweek
- Regular rate, overtime hours and overtime premium calculated automatically
- A comparison with overtime on the base rate alone, so underpayments stand out
- Example sheet (30 base hours + 16 night hours) and instructions
Prefer to calculate online? Use the shift differential calculator.
Frequently asked questions
Do shift differentials count toward overtime?
Yes. A shift differential is part of the regular rate of pay (29 CFR 778.207(b)), so overtime must be paid on the weighted average of the base and differential rates, not on the base rate alone.
Can I enter a percentage differential?
Yes. Choose % and enter, for example, 10 for a 10% night differential. Choose $ for a flat amount per hour.