What this shift schedule template is for
Continuous operations that run three 8-hour shifts a day, seven days a week, cannot be staffed by three teams: nobody would get a day off. The standard answer is four teams, with three working and one off on any given day, rotating so every team moves through morning, afternoon and night. This template builds that rotation for you over a four-week cycle and shows whether coverage holds on every day.
It is the pattern used in most Indian manufacturing plants, process industries, power and utility control rooms, hospital support services and 24-hour BPO floors. The teams are labelled A, B, C and D, the shifts I (06-14), II (14-22) and III (22-06), and the fourth state is OFF. The 3-shift roster patterns article explains the alternatives; this template implements the most common one.
Who uses it: plant HR, shift in-charges and production planners who need to publish a month's shift chart on the notice board, and payroll executives who need night-shift counts and weekly hours per team.
What is inside: 3-Shift Rotation, Employees and Timings sheets
The 3-Shift Rotation sheet is the chart. Rows are the four teams A, B, C and D; columns are the 28 days of the four-week cycle, grouped by week. Each cell shows I, II, III or OFF. The rotation moves each team forward one shift each week: in week 1 team A is on I, B on II, C on III and D OFF; in week 2 A moves to II, B to III, C is OFF and D takes I; and so on. Team members rotate weekly, so within each week a team keeps the same shift and takes its weekly off within that week (the template marks one OFF day per team per working week and the whole fourth week as the rest-and-reserve week; you can adjust to a 6-on-1-off pattern in the Timings sheet).
Below the team rows is a coverage check for each date: three cells that count how many teams are on I, II and III that day, using =COUNTIF(B5:B8,"I") and so on. Each should read 1. A cell reading 0 means an unstaffed shift and a cell reading 2 means two teams on the same shift, which happens when someone edits the pattern by hand. A hours row computes hours per team per week as shifts worked x 8.
The Employees sheet lists every worker with Emp ID, Name, Department and Team (A to D) so that the chart's team code translates into named people. A COUNTIF per team shows team sizes so you can keep them balanced. The Timings sheet holds the start and end times for I, II and III and the shift length used in the hours row; changing 06:00 to 07:00 there updates the chart headers and any exported roster.
- Cycle length is 28 days; copy the block forward for a full calendar month and align the start date to a Monday or to your plant's week
- Coverage cells use conditional formatting: green when 1, red otherwise
- Team size is shown on the Employees sheet so that each shift has the same headcount
How to use it: from cycle to calendar
Decide the cycle start date and enter it in the top-left cell; the day headers fill from it. Assign every employee to a team on the Employees sheet, keeping teams equal in size and skill mix (each team needs its own fitter, electrician and line leader if the plant needs one per shift). Then read the chart: it tells each team what shift they are on each week.
To publish, print the 3-Shift Rotation sheet for the notice board and, if you want individual rosters, filter the Employees sheet by team and staple the chart to it. The chart repeats every four weeks, so once employees learn their team they can predict their shift months ahead, which is the main advantage of a fixed rotation over an ad hoc roster.
At month end, count each team's III shifts for the night allowance and read the hours row for overtime. Because the pattern is fixed, these totals are the same for every team over a full cycle, which simplifies payroll. Any deviation (a team held back for maintenance, a public holiday) is handled by editing the affected cells and letting the coverage check confirm the result.
- Rotate forward (I to II to III), not backward; forward rotation is easier on sleep
- Give at least 24 hours between a night shift and the next morning shift when changing over
- Keep a printed copy of the cycle at the time office for attendance reconciliation
How to customise shifts, teams and cycle
Change shift times on the Timings sheet to match your plant: 07-15, 15-23, 23-07 is as common as 06-14. If you run two shifts plus a general shift (for example I, II and G 09-18 for staff functions), replace III with G in the chart and adjust the coverage counts. For a three-team rotation on a six-day week with Sunday closed, remove team D and set Sunday columns to OFF for all teams; the coverage check will show 0 on Sundays, which is correct for a closed plant.
For plants with different headcounts per shift (more on I and II, fewer on III), keep the four-team chart for the core crew and use the duty roster format for the variable staff. For 12-hour shifts, use the 12-hour shift schedule template instead; a 3-shift chart cannot be stretched to 12 hours without breaking coverage.
The rotation period can be changed from weekly to fortnightly by duplicating each week's column block; some plants prefer slower rotation so bodies adapt. The rotating shift schedule examples article compares weekly and fortnightly rotation with their fatigue trade-offs.
- Rename teams to your plant's convention (Red, Blue, Green, Yellow) on both sheets
- Add a Supervisor row per team on the Employees sheet so the shift in-charge is visible on the chart
- Lock the Timings sheet so shift hours change only with HR approval
Rules and compliance context
A 4-team, 3-shift rotation exists to keep every worker inside the 48-hour week required by the Factories Act (sections 51 and 54) and continued by the Labour Codes. With six 8-hour shifts a week each team works 48 hours and receives one weekly off, which satisfies section 52. Anything beyond that, such as a team held over into a second shift during a breakdown, is overtime at twice the ordinary rate under section 59.
The Factories Act also requires that the periods of work and the shift system be displayed in the factory and notified to the Inspector, and that a worker not be moved from one shift to another except in the manner and after the interval the Act and state rules prescribe. A published cycle chart like this one is the practical way to meet the display requirement. Rest intervals (30 minutes after 5 hours) must fit within each 8-hour shift.
Night shift III (22-06) crosses midnight, which affects how a day is counted for weekly off and for attendance. Most plants treat the shift as belonging to the day it starts. Whatever convention you use, write it on the Timings sheet and apply it consistently to attendance and wages. The working hours as per labour law article summarises the limits.
When the Excel shift chart stops working
The chart is good at the pattern and bad at exceptions. A worker on leave has to be covered by someone from the OFF team, which means overtime and a manual note. Two plants on different cycles need two charts and a supervisor who remembers both. And when attendance is punched on a biometric device, someone still has to compare each punch against the shift that team was on that day to find late marks and early exits.
Attend Mitra's shift templates and roster presets hold the I, II, III and OFF pattern, publish it to each worker's phone by team, and handle exceptions with open shifts and approved swaps. Attendance punched by face, kiosk or biometric device is matched to the rostered shift, including shifts that cross midnight, so night counts, grace periods and overtime are computed rather than reconciled by hand. The shift management software for factories page describes the plant setup, and the shift roster glossary entry defines the terminology used above.