Calculated Shift Pattern Results
These values assume the pattern repeats continuously across the year.
| Shift Type | Count in Cycle | Gross Hours / Shift | Paid Hours / Shift | Cycle Paid Hours |
|---|---|---|---|---|
| Submit the form to populate detailed results. | ||||
Shift Pattern Inputs
Use this calculator for rota planning, payroll estimates, staffing capacity, and contract hour reviews in HR & People Ops.
Hours and Cost Analysis Graph
Example Data Table
| Example Pattern | Day Shifts | Night Shifts | Flex Shifts | Off Days | Cycle Paid Hours | Average Weekly Hours | Employees |
|---|---|---|---|---|---|---|---|
| 4 on 4 off rotating plan | 4 × 11.00 hrs | 4 × 11.00 hrs | 2 × 7.50 hrs | 4 | 103.00 hrs | 51.50 hrs | 12 |
| Continental hybrid rota | 3 × 12.00 hrs | 3 × 12.00 hrs | 1 × 8.00 hrs | 7 | 80.00 hrs | 37.33 hrs | 20 |
| Weekly service desk pattern | 5 × 7.50 hrs | 0 | 1 × 6.00 hrs | 1 | 43.50 hrs | 43.50 hrs | 8 |
Formula Used
Gross Shift Hours = Shift End − Shift Start
If the end time is earlier than the start time, the calculator treats the shift as overnight and adds 24 hours.
Paid Shift Hours = Gross Shift Hours − (Unpaid Break Minutes ÷ 60)
Cycle Paid Hours = (Day Shift Count × Day Paid Hours) + (Night Shift Count × Night Paid Hours) + (Flex Shift Count × Flex Paid Hours)
Average Weekly Hours = (Cycle Paid Hours ÷ Total Cycle Days) × 7
Monthly Hours = Average Weekly Hours × 52 ÷ 12
Annual Hours = Average Weekly Hours × 52
Overtime Hours = Max(0, Average Weekly Hours − Overtime Threshold)
FTE Load Ratio = Average Weekly Hours ÷ Full-Time Standard Weekly Hours
Regular Weekly Pay = Regular Hours × Hourly Rate
Overtime Weekly Pay = Overtime Hours × Hourly Rate × Overtime Multiplier
Weekly Allowance = (Worked Shifts × Allowance Per Shift ÷ Cycle Days) × 7
Team Weekly Payroll = Employees × (Regular Weekly Pay + Overtime Weekly Pay + Weekly Allowance)
How to Use This Calculator
- Enter a pattern name and the number of employees assigned to that rota.
- Add the number of off days in the full shift cycle.
- For each active shift type, enter the count, start time, end time, and unpaid break minutes.
- The calculator automatically handles overnight shifts when the end time falls on the next day.
- Set the full-time weekly standard, overtime threshold, hourly rate, overtime multiplier, and any allowance paid per shift.
- Click Calculate Pattern Hours to show results under the header and above the form.
- Review cycle hours, average weekly hours, overtime exposure, FTE load ratio, team capacity, and payroll estimates.
- Use the CSV or PDF buttons to save the summary for managers, payroll, or workforce planning reviews.
FAQs
1) Does this calculator handle overnight shifts?
Yes. If a shift ends earlier than it starts, the calculator assumes the end time falls on the next day and adds 24 hours before deducting unpaid breaks.
2) Are unpaid breaks removed from paid hours?
Yes. Unpaid break minutes are converted to hours and subtracted from gross shift length, so the reported paid hours better match payroll and contract planning.
3) What does average weekly hours mean?
It is the employee’s cycle paid hours spread across the full cycle length, then converted to a seven-day week. This helps compare rotating patterns fairly.
4) Can I use this for contract reviews?
Yes. HR teams can compare weekly averages, annualised hours, and FTE load against contract terms, working time policies, and staffing assumptions.
5) How is overtime estimated here?
The calculator compares average weekly hours with the overtime threshold you enter. Any excess is treated as overtime for planning and cost estimation.
6) Is payroll output exact for every workplace?
No. It is a planning estimate. Real payroll can vary due to premiums, public holidays, local laws, rounding rules, union terms, and contract exceptions.
7) What is the FTE load ratio used for?
It shows how the pattern compares with a standard full-time week. A value above 1.00 means the pattern averages more than the standard.
8) When should I export the report?
Export after checking the result cards and detail table. The CSV is useful for analysis, while the PDF is better for approvals and meeting packs.