How to make an employee schedule: a step-by-step guide for shift teams
By Jean Luc Poitier, SEO and growth marketing strategist · Connecteam Reviews · Updated September 30, 2026 · Checked November 1, 2026
Disclosure: this site reviews Connecteam and earns a commission if you sign up for it through our links. Connecteam is one option below, and we say where it isn't the right fix.
A good shift schedule puts the right number of people on each shift, stays inside your labor budget, respects when people can work, and reaches everyone early enough to plan around. You can build one with a spreadsheet. This guide walks through the manual method first, then covers when a scheduling app saves enough time to be worth it.
You need four things before you start: a list of your staff with their roles and pay rates, each person's availability, the hours you need covered, and a weekly labor budget.
Employee schedule checklist at a glance
| Step | How | Why it matters |
|---|---|---|
| 1. Collect availability and time off | Every week, in one place | No shifts given to people who can't work them |
| 2. Map coverage by hour and role | From your own sales or traffic history | Staff the peaks, trim the quiet hours |
| 3. Set a labor budget | Hours or dollars per week | Keeps the schedule tied to what you can afford |
| 4. Build the grid | Spreadsheet: people by days | One view of every shift and total |
| 5. Fill shifts in order | Fixed shifts, peaks, then gaps | Avoids reshuffling the whole week |
| 6. Check hours and rest | Overtime, clopenings, minors | Catches costly or unlawful shifts |
| 7. Post early and confirm | Same day each week | People can plan their lives |
| 8. Handle swaps and review | A written swap rule; compare planned vs actual | Next week's schedule gets better |
How to make an employee schedule in 8 steps
1. Collect availability and time-off requests
Ask everyone for their standing availability (the days and hours they can work) and any time off for the coming weeks, and set a deadline, such as a week before you build the schedule. Keep it in one place: a shared sheet, a form, or a tab in your schedule file. Availability collected in text messages is how shifts get assigned to people who can't work them. Note each person's preferred and maximum hours too.
2. Map the coverage you need, hour by hour
List your opening hours, then mark how many people you need in each role for each part of the day. Use your own records: sales by hour from your POS, foot traffic, delivery windows, or job bookings. Most businesses have clear peaks. Write the coverage down as a simple table (for example, “Saturday 11 to 2: two cooks, three servers, one host”) so you are filling slots instead of guessing.
3. Set a labor budget for the week
Decide how many paid hours, or how many dollars of wages, the week can carry. One way is to start from projected sales and a labor cost target that fits your margins: if you expect $10,000 in sales and want labor at 25% of that, the budget is $2,500 in wages. The target is your call, but you need a number to check the schedule against. Remember that employer payroll taxes and overtime premiums sit on top of base wages.
4. Build the schedule grid in a spreadsheet
A layout that works in Excel or Google Sheets:
- One row per employee, with columns for name, role, and hourly rate.
- One column per day, each holding a shift as start and end time (or two columns per day).
- A weekly hours column that adds up each person's shifts, minus unpaid breaks. In Sheets or Excel, (end minus start) times 24 turns a time difference into hours.
- A cost column (weekly hours times rate) and a total at the bottom to compare with your budget.
- A coverage row under each day that counts people on shift in each block, so gaps stand out.
- Conditional formatting that turns a cell red when someone passes 40 hours.
Save it as a template. Next week you copy the tab and only change what moved.
5. Fill shifts in a set order
Place the fixed pieces first: approved time off, anyone with a set schedule, and your openers and closers. Then staff the peaks you mapped in step 2, putting experienced people where the pressure is highest. Fill the remaining gaps last, favoring people under their preferred hours. Spread the less popular shifts, like weekends and closes, around the team so the same people aren't stuck with them every week.
6. Check hours, rest, and the rules that apply to you
Before you post, look at each row and each day:
- Overtime. Under the federal Fair Labor Standards Act, covered nonexempt employees get at least time and one-half their regular rate for hours over 40 in a workweek (US Department of Labor). State rules can be stricter, so check yours too.
- Rest between shifts. Look for clopenings. Some jurisdictions regulate them: Oregon's predictive scheduling law, which covers retail, hospitality, and food service employers with 500 or more employees worldwide, requires written schedules 14 calendar days ahead and a 10-hour rest period between shifts unless the employee agrees (Oregon Bureau of Labor and Industries).
- Breaks, meal periods, and hours for minors. These vary by state and sometimes by city. Check your state labor department's site for the rules that cover your business.
- Budget. Compare the total cost to step 3 and trim the quietest hours first.
7. Post the schedule early and get it confirmed
Publish on the same day every week, as far ahead as you can manage, and put it where everyone looks: a shared link, a group chat, or a printed copy by the time clock. Ask people to confirm they have seen it. Changes after posting should go out the same way, with the changed shift called out so nobody has to hunt for it in a new version of the file.
8. Handle swaps and call-outs, then review the week
Write down a swap rule and share it: who can swap with whom (same role, trained on the station), whether a manager has to approve, and how the change is recorded. For call-outs, keep a short list of people who want extra hours. At the end of the week, compare the schedule with the hours actually worked. Repeated gaps and overtime show you where next week's schedule needs to change.
When a spreadsheet schedule stops working
A spreadsheet is fine for a handful of people on steady shifts. It gets harder when availability changes weekly, people swap shifts by text, you need to know who actually clocked in, or you have more than one location. At that point you spend more time chasing messages and re-sending files than building the schedule.
Connecteam is one shortcut. Its Small Business Plan is free for up to 10 users and includes the scheduler with repeating shifts and templates, open shifts employees can claim, shift replacements, auto-scheduling, a GPS time clock, and team chat in one app. Its limits: one schedule and one time clock, no payroll integration on the free plan, and every hub is billed separately once you pass 10 users. Reviewers also mention a learning curve for admins and upsell calls. The details are in Connecteam free vs paid and on our Connecteam review page.
If you mostly need scheduling for a larger team, compare the options in the best employee scheduling apps; Sling's free plan, for instance, covers scheduling for up to 30 users.
Employee scheduling FAQ
How far in advance should you post an employee schedule?+
There is no single US rule. Some places have predictive scheduling laws for certain employers; Oregon, for example, requires covered retail, hospitality, and food service employers with 500 or more employees worldwide to give schedules in writing at least 14 calendar days ahead. Where no such law applies, pick a lead time you can keep every week and stick to it.
How do I make an employee schedule in Excel or Google Sheets?+
Put employees in rows and days in columns, enter each shift as a start and end time, and add a column that totals weekly hours with a formula. Add a cost column (hours times wage) and compare the total to your labor budget. Conditional formatting that highlights anyone over 40 hours helps you catch overtime before you publish.
What is a clopening shift?+
A clopening is when the same person closes at night and opens the next morning, leaving little time to rest. Some predictive scheduling laws limit it; Oregon's requires a 10-hour rest period between shifts for covered employers unless the employee agrees. Even where it's legal, check for it before you post.
Is there a free employee scheduling app?+
Several have free tiers. Connecteam's Small Business Plan is free for up to 10 users and includes scheduling and a GPS time clock. Sling schedules up to 30 users free, without a time clock. Homebase and 7shifts have free plans for one location with up to 10 and 15 employees.