Use this HR & People Ops calculator to estimate shift span, paid hours, overtime, night premiums, and projected labor cost for one employee shift.
Calculator Form
Example Data Table
| Employee | Shift | Break | Rate | Paid Hours | Overtime | Night Hours | Gross Pay |
|---|---|---|---|---|---|---|---|
| Alex Morgan | 09:00 - 18:00 | 13:00 / 60 min | $20.00 | 8.00 | 0.00 | 0.00 | $160.00 |
| Jamie Patel | 20:00 - 05:00 | 00:30 / 30 min | $18.00 | 8.50 | 0.50 | 6.50 | $170.50 |
| Riley Chen | 07:30 - 16:30 | 12:00 / 45 min | $22.00 | 8.25 | 0.25 | 0.00 | $184.25 |
Formula Used
1. Shift Span Hours
Shift Span = End Time − Start Time. Overnight shifts add 24 hours when the end falls on the next day.
2. Paid Hours
Paid Hours = Shift Span − Unpaid Break Hours.
3. Regular Hours
Regular Hours = Minimum of Paid Hours and Overtime Threshold.
4. Overtime Hours
Overtime Hours = Paid Hours − Overtime Threshold, but never below zero.
5. Night Hours
Night Hours = Overlap between worked time and the night premium window. If break start is blank, the unpaid break is centered automatically.
6. Gross Pay
Gross Pay = (Regular Hours × Hourly Rate) + (Overtime Hours × Hourly Rate × Overtime Multiplier) + (Night Hours × Night Premium Per Hour).
How to Use This Calculator
- Enter the employee name and shift date.
- Add shift start and end times.
- Enter the unpaid break minutes.
- Provide a break start time for exact night calculations.
- Set the hourly rate, overtime threshold, and multiplier.
- Define the night premium window and hourly premium amount.
- Click Calculate Shift to display the results above the form.
- Use the CSV or PDF buttons to save the output.
Frequently Asked Questions
1. Can this calculator handle overnight shifts?
Yes. If the end time is earlier than the start time, the calculator treats the shift as crossing midnight and adds the correct next-day hours automatically.
2. What happens if I leave break start empty?
The tool centers the unpaid break inside the shift. This gives a practical estimate when you know break length but do not know the exact break timing.
3. Does night premium replace overtime pay?
No. This setup adds night premium on top of base and overtime pay. That reflects many workplace policies, but you should match the method to your local rules.
4. Can I use different overtime thresholds?
Yes. Enter any overtime trigger you use, such as 8 hours, 7.5 hours, or another internal threshold based on your scheduling policy.
5. Is the break always unpaid?
In this calculator, the break minutes reduce paid hours. If your policy includes paid breaks, enter zero unpaid minutes or adjust the rate method outside this page.
6. What do the CSV and PDF downloads include?
They export the displayed result summary, including shift window, paid hours, overtime hours, night hours, and pay values for easy recordkeeping.
7. Can I compare multiple shifts here?
This page calculates one shift at a time. You can save each result with CSV or PDF, then compare several shifts in your own spreadsheet or payroll file.
8. Is this calculator a substitute for payroll compliance review?
No. It is a planning and estimation tool. Always confirm labor rules, union terms, overtime laws, and payroll settings with your legal or HR operations process.