What this 12-hour shift schedule is for
Two 12-hour shifts a day with four crews is the other standard way to run a 24x7 operation. Compared with three 8-hour shifts, it means fewer handovers, more full days off, and a schedule that most crews prefer once they are used to it. It is common in Indian security deployments, hospital emergency and ICU support, data centres, control rooms, cold storage, and process plants that run lean at night.
The template gives you the two most used 12-hour patterns ready to copy: the 2-2-3 (often called Panama or Pitman) rotation, and the simpler 4-on-4-off. Both use four crews and both average 42 hours a week over the cycle, which matters for the Indian legal position discussed below. The 12-hour shift schedules for 24x7 coverage article compares the patterns in depth; this page is about the spreadsheet.
Who uses it: operations managers planning crews, HR publishing a monthly chart, and payroll executives who need the weekly and monthly hours per crew to compute overtime correctly.
What is inside: 2-2-3 Panama, 4-on-4-off and Notes sheets
The 2-2-3 Panama sheet has four crew rows (Crew 1 to Crew 4) and 28 day columns making a complete cycle. Cells show D (day shift, say 08-20), N (night shift, 20-08) or OFF. The pattern for a crew is: 2 on, 2 off, 3 on, 2 off, 2 on, 3 off, repeating over 14 days on days, then the same 14 days on nights. Crews 1 and 2 pair up to cover days (when Crew 1 is on, Crew 2 is off), Crews 3 and 4 cover nights, and after 14 days the pairs swap between day and night. Every crew gets every other weekend off as a three-day break.
Below the crew rows are two calculated blocks. A Hours per Crew per Week block counts D and N codes in each 7-day group and multiplies by 12: =(COUNTIF(B5:H5,"D")+COUNTIF(B5:H5,"N"))*12. Over the cycle this shows the alternating 36- and 48-hour weeks that average 42. A Coverage row counts crews on D and on N for each date, =COUNTIF(B5:B8,"D") and =COUNTIF(B5:B8,"N"), each of which should read exactly 1.
The 4-on-4-off sheet has the same layout with the simpler pattern: each crew works 4 consecutive 12-hour shifts, rests 4 days, and the four crews are offset by 2 days so that days and nights are always covered. Crews typically alternate between day and night blocks. The Notes sheet carries the legal hours reminder: a 48-hour weekly limit, the fact that any 12-hour shift includes 3 or more hours beyond a standard 8 or 9-hour day, and the double-rate overtime rule, along with the shift timings used by both charts.
- The D and N shift times are set once on the Notes sheet and referenced by both charts
- Week boundaries in the hours block start on the cycle start date; align it to your payroll week
- Coverage cells are conditionally formatted green for 1 and red for anything else
How to use it: choosing a pattern and publishing
Pick the pattern first. 2-2-3 gives frequent short breaks and a long weekend every other week, but no long stretch off; 4-on-4-off gives four-day breaks but four consecutive 12-hour shifts, which is tiring for physically demanding posts. Enter your cycle start date in the top-left cell of the chosen sheet so the day headers show real dates, then assign employees to crews on paper or in a separate list, keeping crews equal in size and skill.
Print the chosen sheet for the notice board or export it to PDF for the team group. Because the cycle repeats every 28 days, you can print three months at once by copying the block forward. Mark planned leave and public holidays on a copy rather than the master, so the master pattern stays clean for the next cycle.
At month end, read the Hours per Crew block. In a 30-day month a crew on either pattern works about 15 shifts, or 180 hours. That is under the 48-hour weekly norm on average, but individual weeks reach 48 hours and every shift runs 12 hours against a standard 9-hour day, so daily overtime still arises under the Factories Act unless your state has notified a 12-hour exemption. Hand the shift counts and the hours to payroll with the overtime pay calculator to compute what is due.
- Publish at least two weeks ahead; 12-hour crews plan their lives around the long breaks
- Rotate day and night pairs every 14 days (2-2-3) or every block (4-on-4-off), never mid-block
- Keep the same crew composition through the cycle so handovers happen between the same two crews
How to customise crews, timings and the cycle
Change the shift times on the Notes sheet: 07-19 and 19-07 are as common as 08-20 and 20-08. If you need a third, short overlap shift for handover (say a 30-minute overlap), extend the shift length in the Notes sheet to 12.5 hours and the hours formulas will follow. For a site that closes on Sundays, set all crews to OFF in the Sunday columns; the coverage check will show 0, which is correct.
To add a fifth crew for leave cover (a common Indian practice, since four crews leave no slack for casual leave), add a Crew 5 row filled with OFF and use it as the reliever pool, or reduce each crew's size and hold a floating reliever list. The security guard duty roster template shows the reliever approach used in guarding.
If your organisation prefers fixed nights (some staff only work nights by choice), drop the 14-day day-night swap in the 2-2-3 sheet: Crews 1 and 2 stay on D and Crews 3 and 4 stay on N. Note this on the Notes sheet, since fixed nights affect night allowance and the health-check rules discussed below. The rotational shift glossary entry summarises the fixed-versus-rotating trade-off.
- Rename crews to A, B, C, D or to colours to match your existing practice
- Add an Employees sheet with Emp ID, Name and Crew if you want names on the printout
- Add a Nights per Crew column with =COUNTIF(row,"N") for the night allowance
Rules and compliance context: 12-hour shifts under Indian law
A 12-hour shift sits uneasily with the Factories Act 1948, which caps daily hours at 9 and the spread-over at 10.5 hours, and with most state Shops and Establishments Acts, which have similar limits. Factories can run 12-hour shifts only under exemptions notified by the state government or by paying the hours beyond 9 as overtime at double rate under section 59, and several states have notified rules allowing 12-hour shifts within a 48-hour week. The Labour Codes keep the 48-hour weekly cap and leave daily hours (8 to 12 depending on spread-over) to be notified by the appropriate government, which is why the legal position now varies by state.
Practically, this means three things for anyone using this template. First, check your state's current notification on daily hours before adopting a 12-hour pattern. Second, budget for overtime: even where 12-hour shifts are permitted, hours beyond the notified daily limit or beyond 48 in a week are payable at twice the ordinary rate, and under the Codes overtime requires the worker's consent. Third, watch the spread-over: the time from the start to the end of the shift including breaks should stay within the notified limit, so a 12-hour post with a one-hour unpaid break already reaches 13 hours of spread-over.
Weekly off is still required. Both patterns in this template give more than one off day a week on average, but in a 48-hour week under 2-2-3 the crew works 4 shifts with 3 off days, so the requirement is met. The OSH Code adds a free annual health check-up for workers above 40 in covered establishments; night crews are an obvious priority. The overtime calculation formula article shows how 12-hour shift hours convert to overtime pay using the monthly wage divided by 26 and then by 8.
When the Excel schedule stops working
A 12-hour chart is stable until real life edits it. A crew member on sick leave means an 8-hour or 12-hour extension for someone else, which is overtime that must be recorded, consented to and paid. Public holidays falling on a crew's working day create holiday-pay questions. And the chart cannot tell you whether the night crew actually arrived at 20:00 or 21:15, or whether a handover happened at all.
Attend Mitra handles 12-hour and midnight-crossing shifts natively: shift templates for D and N with their own grace and break rules, a roster preset for the 2-2-3 or 4-on-4-off cycle that publishes to each crew member's phone, swap requests with approval, and attendance marked by face, kiosk or GPS that is matched to the rostered shift so daily and weekly hours, night counts and overtime are computed for payroll. For 24x7 rotas beyond a single site, see the 24x7 rota management guide and the shift solution page.