Free Excel template
Free shift schedule template for Excel
Plan the week’s shifts with one row per employee. The template works out the hours, shows the staffing for each day and flags when there’s too little rest between two shifts.
Excel file (.xlsx) · Opens in Excel, Google Sheets and LibreOffice · No sign-up
What’s in the shift schedule
The shift schedule is made for shops, cafés, clinics and other small workplaces where shifts change from week to week.
The whole week on one sheet
One row per employee and a start and end column for each day from Monday to Sunday. Enter the week’s Monday, and the dates and week number fill in.
Hours per employee
The scheduled hours after breaks sit next to the contracted weekly hours, so you see who has too many or too few.
Overview per day
At the bottom you see how many are on shift and the scheduled hours for each day, so gaps in staffing are easy to spot.
Rest period check
The template flags less than 11 hours of rest between two shifts, a week without a day off and more than 48 hours in the week.
A blank 4-week schedule
An extra sheet with four weeks one below the other. You enter the names once, and a summary shows the hours for all four weeks and the average per week.
Examples and instructions
Four example shifts show how to fill in the sheet – including a late close before an early open. Overwrite them or delete them.
How to fill in the template
- 1
Enter the week’s Monday
The dates for the whole week and the week number fill in by themselves.
- 2
Add the employees
Enter each name, the contracted hours per week and the break per shift in minutes.
- 3
Add the shifts
Enter the start and end as hh:mm. Leave the cells empty on days off.
- 4
Check and share the schedule
Fix the shifts flagged in the Check column, and share the schedule with employees in good time.
Rest and working time in the shift schedule
A shift schedule doesn’t just have to cover your opening hours. It also has to give employees the rest they are entitled to.
Daily rest: 11 hours
Under the EU Working Time Directive, a worker is as a rule entitled to at least 11 consecutive hours of rest in every 24 hours. If a shift ends at 22:00, the next shift should start at 09:00 the next morning at the earliest.
National rules and agreements can allow exceptions in some cases or sectors, but only when the conditions are met. The switch from a late closing shift to an early opening shift is the easiest one to miss.
Weekly rest
In every seven-day period, a worker is as a rule entitled to an uninterrupted rest of 24 hours on top of the 11 hours of daily rest. If you schedule shifts on all seven days of the week, check that every employee gets their day off.
No more than 48 hours on average
The average working week, overtime included, may not exceed 48 hours over a reference period. So one busy week can be fine, but many busy weeks in a row are not. Some countries set a lower limit, so check what applies where you are.
Good scheduling habits
The template helps with the obvious. The rest comes down to habits:
- Start with the need – how many people you need when – then assign the employees.
- Avoid putting an employee on opening the day after a late close.
- Compare the scheduled hours with each employee’s contracted hours.
- Share the whole schedule in good time, e.g. every Thursday for the next week.
- Record the actual working time, so you can document what was worked.
Read more in our guides How to make a work schedule and Work schedules, rest periods and working hours.
This is general information, not legal advice. Always check the rules in your country and any agreements that apply to your business.
When the spreadsheet no longer does the job
A shift schedule in Excel is quick to get started with. The problems start when the schedule has to be shared and changed.
- The schedule is printed, sent as a file or shared as a screenshot, and someone works from an old version.
- Changes and shift swaps happen in the group chat and don’t always make it into the sheet.
- You have to check vacation somewhere else before you add the shifts.
- You have to keep an eye on rest from Sunday to Monday and the average over several weeks yourself.
- The scheduled shifts have to be typed in again when working time is recorded.
How Weekplace does the same job
- You plan the week as a draft, and employees see it on their phone once you confirm it.
- Save your usual week as the default schedule, or copy last week.
- Post open shifts that employees claim themselves, and let them swap shifts with each other.
- Vacation days show right in the schedule, and an employee on vacation can’t be given a shift.
- The schedule warns about less than 11 hours of rest – from Sunday to Monday too – and about the 48-hour rule over 4 months.
- When an employee records time on a day with a shift, the hours are suggested from the shift.
See how shift scheduling in Weekplace works.
Pay once
€199
one-time · excl. VAT
The same price whatever the number of employees. Pay once and use Weekplace forever.
- Time tracking, shift scheduling, vacation and absence
- Unlimited employees
- No subscription and no monthly payments
No payment to get started
Frequently asked questions about shift schedules
How do you make a shift schedule in Excel?
Make one row per employee and a column for the start and end of each day, and let a formula work out the hours. This template has it all: hours per employee and day, a comparison with the contracted hours and a rest period check. Start with the staffing you need, then assign the employees.
What is the 11-hour rule?
Under the EU Working Time Directive, a worker is as a rule entitled to at least 11 consecutive hours of rest in every 24 hours. If a shift ends at 22:00, the next shift should start at 09:00 the next morning at the earliest. National rules and agreements can allow exceptions in some cases or sectors.
Can a shift go past midnight in the template?
Yes. If a shift ends before it starts, e.g. 18:00–02:00, it counts as a shift that ends the next day. The rest before the next day’s shift is also counted from the next day.
Does the template check rest between two weeks?
No. The weekly schedule only looks at the week in the sheet, so you have to watch out for a late Sunday shift followed by an early Monday shift yourself. The same goes for the 48-hour rule, which is an average over a longer period.
Is a shift schedule the same as time tracking?
No. The shift schedule is the planned working time. The actual working time has to be recorded separately, e.g. on a timesheet or in a time tracking system.
Read also about shift scheduling and time tracking in one system.
More free templates: timesheet and vacation planner – or see all templates.