How to create a shift schedule step by step

Organising a team’s shifts is one of those tasks that look simple until you sit down to do them. Covering every time slot, respecting the legal rest periods, avoiding overlaps and making sure nobody gets lumped with two back-to-back shifts… it all has to add up. And if your company works with rotating shifts, things get even trickier. In this guide we explain what a shift schedule is, what requirements it must meet under current regulations and how to build one step by step, whether in Excel or with dedicated software.

What is a shift schedule?

A shift schedule is the document that sets out each employee’s working hours within a given period. It shows who works, in which time slot and on which days, so that the whole team knows in advance when they are due to clock in and clock out.

That period can be weekly, monthly, quarterly or even annual, depending on the sector and the stability of the activity. In hospitality or retail it tends to be planned with a shorter horizon; in industry or healthcare, where rotating shifts are well established, teams work with calendars spanning several months.

The goal is twofold: to guarantee that the company’s activity is always covered and, at the same time, that every worker is clear about their hours, their rest periods and their time off.

Essential requirements of a work schedule

For a schedule to do its job, it is not enough to hand out hours at random. It must meet several requirements:

Visual clarity. Anyone should be able to understand it at a glance: who works, when and on which shift. No ambiguities and no cells that could be read two different ways.
Advance planning. The company is obliged to communicate the work calendar with enough notice for the worker to organise their personal life. Publishing it a day ahead is neither good practice nor usually in line with what the collective agreement requires.
Respect for legal rest periods. The Estatuto de los Trabajadores (Spain’s Workers’ Statute) sets a minimum rest of 12 hours between the end of one working day and the start of the next, and a minimum weekly rest of one and a half uninterrupted days. The schedule must always respect these.
Compliance with the collective agreement. Many collective agreements regulate shift rotation, night-work limits or the notice period for communicating changes. The schedule must comply with whatever your collective agreement states.
Consistency with the time record. Since 2019, time tracking has been mandatory in Spain, so the schedule must match what is later reflected in each employee’s daily clock-in record.

Rotating work shift schedule

Rotating shifts are those in which workers change time slots cyclically: one week on mornings, another on afternoons and another on nights, for example. They are common in factories, hospitals, security or any activity that needs round-the-clock cover.

Their advantage is that they share out the least desirable shifts (especially the night shift) fairly across the whole team. Their difficulty is that planning them by hand is tedious and error-prone: you have to make sure the rotation is fair, that the rest periods between shift changes are respected and that nobody moves from a night shift to a morning shift without the mandatory rest hours.

How do you create a shift schedule?

Building a schedule need not be a headache if you follow a logical order. These are the four basic steps.

1. Establish your company’s shifts

The first step is to define which time slots your business needs to cover. The most common approach is to work with three shifts:

Morning shift, for example from 6:00 to 14:00.
Afternoon shift, from 14:00 to 22:00.
Night shift, from 22:00 to 6:00.

Not every company needs all three. A shop might have only a morning and afternoon shift, whereas a factory with continuous production will need to cover all 24 hours. Define your slots before assigning anyone.

2. Determine how many workers you need on each shift

Once the shifts are defined, work out how many people you need on each one. This is influenced by the real workload of each slot (a café does not need the same staff at 8:00 as at 17:00), the tasks that must be covered and the activity peaks.

Also bear in mind the foreseeable absences: holidays, sick leave, time off. A good schedule leaves room for the unexpected without the business suffering. This is where having your holiday management software well organised makes the difference, because you can see at a glance who is available.

3. Distribute workers across shifts

With the shifts and the number of people clear, it is time to assign names. At this point it is worth considering each worker’s availability, their preferences where possible, seniority and, above all, the constraints of the collective agreement and the law.

Distribute the shifts in a balanced way. If it is always the same people who take on the nights or the weekends, sooner or later conflicts will arise and staff turnover will increase.

4. Build the rotating shift schedule

If your company works with rotation, this is the most delicate step. The idea is to design a cycle that repeats: for example, a pattern of morning-morning-afternoon-afternoon-night-night-off-off that rotates among the different groups of workers.

When setting up the rotation, always check that:

Nobody moves from a night shift to a morning shift without the minimum 12 hours of rest.
The weekly rest is respected in every cycle.
The rotation shares out night shifts and public holidays fairly across all groups.

Once the base cycle is set up, replicating it for the following weeks or months is simply a matter of repeating the pattern.

Work schedule in Excel

Excel is where many SMEs start, and for small teams it can work. The advantage is obvious: it is free (or nearly so) and everyone knows how to handle it, at least at a basic level.

To set up a basic schedule in Excel you can create a table with the days of the month in the columns and the workers’ names in the rows, filling each cell with the corresponding shift (M, A, N or off). Using colours for each shift helps a lot to read it at a glance.

The problem appears when the team grows or the shifts rotate. Excel does not warn you if you have put someone on nights and then on the morning after, it does not monitor rest periods, it does not reconcile holidays automatically and, every time there is a last-minute change, you have to redo it by hand and send it back out to the whole team. On top of that, it is easy for human error to slip in and end up causing a labour dispute or even a penalty.

Work schedule with LapsoWork

When the Excel schedule starts eating up hours every week, it is time to make the leap to dedicated software. With a tool like LapsoWork, shift planning stops being a static spreadsheet and becomes something living and connected with the rest of your people management.

With LapsoWork’s shift software you can:

Plan shifts visually and duplicate rotating patterns with a single click, without rebuilding the schedule from scratch every month.
Automatically detect overlaps, insufficient rest periods or breaches before publishing the calendar.
Notify each employee of their shifts directly on their phone, with alerts whenever something changes.
Reconcile shifts, holidays and absences in a single view, so you never schedule someone who is on sick leave or on holiday.
Connect the schedule to the actual clock-in, so that the time record and the planning match and you comply with the law with no extra effort.

The result is that you spend minutes on what used to take you hours, you reduce errors and you avoid the conflicts that arise when the distribution of shifts is not transparent. And it all stays integrated with your time tracking software, so managing your team’s time is no longer scattered across a thousand places.

Conclusion

Building a good shift schedule comes down to defining the time slots, calculating how many people you need on each one, distributing your team in a balanced way and, if you work with rotation, setting up a fair cycle that always respects the legal rest periods. Excel can do the job to get started, but as soon as the team grows or the shifts rotate, dedicated software saves you time, errors and headaches. Plan ahead, respect the collective agreement and keep the schedule connected to the clock-in: your team will notice, and so will you.