Team shift schedule generator (2x8, 3x8, 12h rotations)
Enter your employees and your pattern (2-shift, 3-shift, day, 12h) and the generator builds a rotation covering every shift, with rest days and an hours summary. Calendar-style Excel export.
Tap a cell to change it (rest, leave…): the checks rerun instantly.
Checks
11 h rest, no more than 6 days in a row, no more than 48 h a week, every shift covered.
Benchmarks: 11 consecutive hours of daily rest (EU Working Time Directive 2003/88/EC, art. 3), a weekly rest day, and a 48-hour average weekly limit (art. 6).
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Schedule — Packing unit | |||||||||||||||||||||||||||||
| 2 | From 05/10/2026 to 01/11/2026 · 3 x 8 continuous · 7 days a week · 5 teams | |||||||||||||||||||||||||||||
| 3 | ||||||||||||||||||||||||||||||
| 4 | Employee | Team | Mo 05/10 | Tu 06/10 | We 07/10 | Th 08/10 | Fr 09/10 | Sa 10/10 | Su 11/10 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 | xx 88/88 |
| 5 | Emma | 1 | M | M | A | A | N | N | R | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 6 | Jack | 2 | A | A | N | N | R | R | R | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 7 | Olivia | 3 | N | N | R | R | R | R | M | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 8 | Harry | 4 | R | R | R | R | M | M | A | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 9 | Sophie | 5 | R | R | M | M | A | A | N | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 10 | Oliver | 1 | M | M | A | A | N | N | R | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 11 | Grace | 2 | A | A | N | N | R | R | R | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 12 | Samir | 3 | N | N | R | R | R | R | M | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 13 | Chloe | 4 | R | R | R | R | M | M | A | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 14 | Liam | 5 | R | R | M | M | A | A | N | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 15 | ||||||||||||||||||||||||||||||
| 16 | Headcount Morning | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| 17 | Headcount Afternoon | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| 18 | Headcount Night | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
Real formulas: change a value and everything recalculates
Opens in Excel, LibreOffice and Google Sheets.
Building a fair rotating schedule by hand takes hours and leads to mistakes. This generator automatically produces a team rotation (2-shift, 3-shift, 12h or day), distributes rest days and calculates each employee's total hours.
How the rotation works
Each employee is assigned a shift (Morning, Afternoon, Night depending on the pattern) that rotates from one week to the next, so the burden of night and weekend shifts is shared.
The rotation cycle lasts as many weeks as there are crews: covering one post 24/7 on three shifts takes roughly five crews — 168 hours to cover each week divided by a contractual week of about 35 to 38 hours gives just under five. That is why continuous patterns are known as five-crew or continental shift systems.
Two consecutive rest days are set each week, staggered from one employee to another to ensure every slot is covered.
Total hours, days worked and nights worked are calculated per employee, which makes working-time records easy to keep and the legal ceilings easy to watch: an average of 48 hours a week over the reference period, and at least 11 consecutive hours of rest between two shifts.
Use cases
- Industry and continuous production (three-shift, continental patterns)
- Healthcare: care homes, clinics and wards on 12-hour shifts
- Security, guarding and reception on rotating shifts
- Logistics, warehousing and retail with extended opening hours
- Hospitality and restaurants with split shifts and staggered service
- Any team whose posts must be covered 6 or 7 days a week
Frequently asked questions
What is a 3-shift (3x8) schedule?
The 3-shift system splits the day into three 8-hour shifts (morning, afternoon, night) to cover 24 hours. Employees rotate across these three slots from week to week.
How many crews does a continuous three-shift operation need?
Covering one post 24 hours a day, 7 days a week means covering 168 hours per week. Divided by a contractual week of about 35 to 38 hours, that comes to just under five crews — the five-crew or continental pattern. With only four crews, weekly rest becomes very hard to guarantee without permanent overtime.
What is the difference between two-shift, three-shift and 12-hour patterns?
A two-shift pattern runs two 8-hour shifts back to back (say 6am–2pm then 2pm–10pm) and leaves the night uncovered. A three-shift pattern adds the night shift and runs continuously. A 12-hour pattern cuts handovers to two a day, at the cost of longer days that need carefully planned rest periods.
Does the schedule respect weekly rest?
The generator sets two rest days per week per employee. Always check compliance with your local labor rules and maximum working hours.
What are the maximum working hours?
Under the EU Working Time Directive and the national rules that implement it, weekly working time must not exceed an average of 48 hours including overtime over the reference period, and workers are entitled to 11 consecutive hours of daily rest plus 24 hours of uninterrupted weekly rest. The per-employee hours summary helps you watch those limits; collective agreements may be more generous.
How are night hours handled?
Night work is defined by national law, usually a period of at least seven hours that includes midnight to 5am. Night workers' normal hours must not exceed an average of 8 hours per 24, with a hard limit for hazardous work. Night workers are also entitled to a health assessment, and most collective agreements add a premium or compensatory rest. The schedule counts nights per employee so that tracking stays simple.
Can I edit the schedule in Excel?
Yes. The .xlsx export is an editable calendar: you can adjust a shift, add an absence or a replacement directly in the file.