How to Make a Work Schedule: A Complete Guide

Making a work schedule was, for the first year of running my business, the task I dreaded most. Every week I sat down with a spreadsheet, a list of who could work when, and a vague memory of who had asked for which day off.

Every week I got something wrong: a shift uncovered, someone scheduled on their kid's recital, an accidental 46-hour week that cost me overtime I had not planned for. Scheduling looks simple until you do it, and then it becomes clear how many moving parts have to line up.

A good work schedule does three things at once: it covers the business when it needs coverage, it respects the lives of the people working it, and it keeps you compliant and on budget. A repeatable process makes that far easier than starting from a blank page every week.

This guide walks through it step by step: what to gather first, a seven-step process, the types of schedules to choose from, how to build one in a spreadsheet, when to move to software, and the overtime and scheduling rules to keep in mind. I built FirstHR to hold the people side of scheduling: employee records, the written scheduling policy and each signed acknowledgment, while the schedule itself comes from the process below. This article is general information, not legal advice.

What Is a Work Schedule?

A work schedule is a plan that sets out when employees are expected to work: their days, their shifts, and their hours. At its simplest, it answers a basic question for every person on the team: when do I need to be here?

For the business, the same document answers the mirror-image question: will I have the right number of people at the right times? A work schedule is the practical tool that matches staffing to demand.

Behind that simple definition sits a balancing act. A work schedule has to satisfy several goals that often pull against each other: enough coverage to run the business, fair and predictable hours for employees, controlled labor costs, and compliance with overtime and scheduling laws.

A schedule can fail in either direction. One that nails coverage but ignores employee availability generates constant conflict and turnover, and one that keeps everyone happy but leaves gaps fails the business. Good scheduling is the craft of satisfying all of these at once.

Work schedules come in many forms, from a fixed Monday-to-Friday office pattern to intricate rotating shift systems that keep a hospital or factory running around the clock. The right form depends entirely on the nature of the work and the pattern of demand.

Before You Build: What to Gather

Before you build, gather three inputs: your coverage needs, employee availability and time-off requests, and your policies. The biggest scheduling mistakes happen before a single shift is assigned, in the rush to start filling in a grid without the information the schedule depends on. Having all three ready turns scheduling into a straightforward assembly job and saves hours of rework.

The first is your coverage needs. Before thinking about people, map out demand: how many workers you need at each hour and each day, based on your busy and quiet periods. A restaurant needs more staff at dinner than mid-afternoon; a store needs more on weekends.

Coverage needs are the target the schedule has to hit, so define them first and build people around them rather than the other way around. If no arrangement of the people you have covers those needs, that is a staffing problem rather than a scheduling one.

The second is employee availability and time-off requests. Collect each person’s availability, standing commitments, and any requested time off before you start assigning shifts. Building a schedule and then discovering it conflicts with three people’s known constraints means starting over.

The third input is your policies: overtime rules, any predictive scheduling requirements in your area, and your own rules on shift swaps and time off. With coverage needs, availability, and policies in hand, the actual building goes quickly.

How to Make a Work Schedule in 7 Steps

With your coverage needs, availability, and policies gathered, building the schedule becomes a clear sequence. These seven steps work whether your team is small or mid-size, and whether you use a spreadsheet or software. The order matters: each step builds on the one before, and skipping ahead is where scheduling goes wrong.

The step most people rush is checking hours and overtime as they assign, rather than after. It is far easier to see a 44-hour week forming and adjust a shift than to discover it when payroll runs. Watching the running total for each person as you build lets you control overtime deliberately, keeping it where you want it rather than where it accidentally lands.

The other step that pays off disproportionately is the last one: managing changes through a single channel. Schedules always change, but when swap requests come by text, time-off requests by email, and call-outs by phone, the schedule drifts out of sync with reality.

One channel fixes that cheaply. Funneling every change through a single process keeps the schedule accurate, tells you who is actually working, and leaves a record, which matters both operationally and for compliance.

Types of Work Schedules

There are six main types of work schedule: fixed, flexible, rotating, split shift, on-call, and compressed. Choosing the right one is among the more consequential scheduling decisions, because the type shapes everything else: coverage, cost, compliance, and how employees experience their work. No type is universally best; each fits a different pattern of demand and a different kind of work.

Most businesses use some combination rather than a single pure type. An office might run fixed schedules for most staff and flexible arrangements for a few roles, or a hybrid work schedule that splits time between office and home.

Round-the-clock operations sit at the other end of the range. They typically use rotating shifts, and the rotation pattern matters a great deal for coverage and fatigue. The 2-2-3 rotation keeps four teams on a site that never closes, and the twelve-hour DuPont schedule runs continuous industrial operations.

The practical way to choose is to start from your coverage pattern and work backward. If demand is steady and predictable, a fixed schedule is simplest. If you need coverage across a longer day, a compressed schedule may fit. It trades longer shifts for more days off; the 9/80 version, for example, gives every other Friday off.

If you never close, a rotating pattern is likely necessary. Spiky, unpredictable demand is the awkward case, and on-call or flexible arrangements are the usual answer. Match the type to the actual shape of your demand rather than adopting a pattern because it is common elsewhere.

One option is off the table whatever you choose. Time off in place of overtime pay, known as comp time, is allowed only for public agencies under 29 U.S.C. 207(o), so a private employer pays the overtime rather than banking it.

Examples of Shift Work in Practice

A retail store might run an opening shift from 7am to 3pm and a closing shift from 2pm to 10pm, overlapping through the busy afternoon. A plant running around the clock usually splits the day three ways: a first shift in the morning, a second shift through the evening, and a third shift overnight.

A restaurant is the classic split shift case, with servers working lunch, going home, and returning for dinner. A clinic often runs fixed weekday hours plus a rotating weekend on-call list.

The overnight examples raise a pay question worth settling early. The Fair Labor Standards Act does not require extra pay for night work, so a shift differential (a higher rate for working nights) is a matter of agreement rather than federal law.

A Work Schedule Example for a Full Week

Here is a finished week for a five-person store that opens at 7am and closes at 10pm. Nobody crosses 40 hours, every hour the doors are open has someone on the floor, and the busiest stretch of the week gets a second person.

Read it the way you would build it. The opening and closing shifts cover the whole day between them, the floater lands on the three busiest days, and the weekend associate takes the mornings the lead does not work. If your state requires an unpaid meal period, subtract it from each shift before you total the week.

How to Make a Work Schedule in Excel or Google Sheets

For many small teams, a spreadsheet is the right tool to start with, and it costs nothing. The basic structure is simple: put employees down the left side, days of the week across the top, and each person's shift times in the cells where their row meets each day.

That grid is the core of nearly every manual schedule, and it works well for a stable team of a handful of people.

A few additions make the spreadsheet genuinely useful rather than just a grid. Add a column on the right that sums each employee's total weekly hours, so you can see at a glance who is approaching overtime.

Coverage is the other thing worth making visible. Add a row or a separate tab that totals the number of people scheduled for each shift, and color-code shifts or roles so the sheet reads at a glance instead of being counted by hand. These small touches turn a static grid into a working tool.

The single most important habit with a spreadsheet schedule is to save it as a reusable template. Most of your schedule is the same from week to week, so starting from last week's structure and adjusting is far faster than building from scratch.

The weekly routine then shrinks to two moves. Duplicate the template, update availability and time off, and you are most of the way done. The spreadsheet approach has real limits as you grow, but for a small, stable team it is often all you need.

Turning the Sheet into a Work Schedule Calendar

A grid is how you build the schedule. A work schedule calendar is how most people prefer to read it. The same data serves both: keep the weekly sheet as your working document, then publish it as a shared team calendar where each shift lands as an event on the right person's phone.

Paper still has a place alongside it. Plenty of small teams post a printed grid somewhere everyone walks past it, which reaches the people who never open a calendar app.

The rule that keeps this from backfiring is one master version. If both the sheet and the calendar can be edited, they drift apart inside a week and nobody knows which one is current. Publish in one direction only. If you would rather not build the grid from scratch, the employee schedule template already has the hours and coverage columns set up.

Spreadsheet vs Scheduling Software

The honest question every growing business faces is when to move from a spreadsheet to dedicated scheduling software. A spreadsheet is free and flexible, but it puts all the work on you: every hours calculation, every availability check, every change is manual.

Software takes that work off you at a price. It automates the arithmetic and the matching, but it costs money and adds a tool to learn, so the right choice depends on where your team sits on a few dimensions.

The tipping point usually arrives when scheduling starts eating serious time each week, or when manual tracking starts producing errors you cannot afford: missed overtime, coverage gaps, or compliance mistakes.

The arithmetic at that point is simple. When you spend hours every week wrestling a spreadsheet, or when a scheduling error costs real money, the monthly cost of software is easily justified by the time and errors it saves. Below that threshold, a spreadsheet is perfectly adequate and the simpler choice.

Whichever tool you choose, it draws on the same underlying people data as the rest of your HR: who works for you, their roles, their availability, and their records. The most efficient setups connect scheduling to that data rather than maintaining it separately, so weigh that when you compare options.

Overtime and Scheduling Laws to Know

Two sets of rules matter most when you build a schedule: overtime and, in a growing number of places, predictive scheduling laws. The schedule you build directly determines your legal exposure under both, so they are worth understanding before you finalize it. Getting either one wrong turns a routine schedule into an expensive liability.

Overtime is the first. Under the Fair Labor Standards Act, non-exempt employees must be paid overtime at time and a half for hours worked over 40 in a workweek. Because the schedule determines how many hours each person works, it is where you control overtime, and watching weekly hours as you build keeps it deliberate.

Daily overtime is the trap for schedules built around long shifts. California requires time and a half past 8 hours in a single day, double time past 12, and time and a half for the first 8 hours on the seventh consecutive day in a workweek. In a state with a daily rule, the length of an individual shift matters as much as the weekly total.

Predictive scheduling, also called fair workweek, is the fast-moving area to watch. These laws give hourly workers more stable schedules by requiring covered employers to post the schedule a set number of days ahead and to pay a premium, often called predictability pay, when a posted schedule changes late.

Oregon's law shows the shape of them. It gives covered employees 14 calendar days of written notice, and the premium for a late change depends on what kind of change it is.

Under Oregon's rules, an employer that adds more than 30 minutes to a shift, or moves its date or start time with no loss of hours, owes an extra hour at the regular rate. Cutting hours or canceling a shift costs half the regular rate for each scheduled hour the employee does not work.

The map runs the other way in places too. Iowa bars its cities from adopting any ordinance that sets scheduling practices beyond what state or federal law requires (Iowa Code 364.3), which rules out a local fair workweek ordinance there entirely.

The practical step is the same everywhere. Check the rules in each place you operate before you build the schedule, and keep a record of what you posted and what changed, because that record is the evidence if a complaint arrives.

Scheduling and Your People Data

The point most scheduling advice misses is that a work schedule is not a standalone document; it is built from your people data. Every schedule draws on the same underlying information: who works for you, their roles and skills, their availability, their time-off balances, and their employment records.

Where that data lives decides how long the job takes. When it sits in one place and the schedule is built from it, scheduling gets faster and more accurate. When it is scattered, you end up maintaining the same information in several places and reconciling the differences by hand.

This is especially true for a small business without a dedicated HR person, where the same owner or office manager handles scheduling, onboarding, records, and compliance. For them, the efficiency comes from not repeating work. In a connected setup, a new hire's availability, role, and start date are captured once during onboarding and feed directly into scheduling, rather than being re-entered.

The schedule also connects to time tracking on the other side. The schedule is the plan; the timesheet is the record of what actually happened. Comparing the two reveals the patterns worth acting on: consistent overtime, frequent absence, or shifts that always run long.

Connection is the whole point. Keeping scheduling, people records, and time tracking together rather than siloed turns scheduling from an isolated weekly chore into part of a coherent picture of your workforce.

Common Scheduling Mistakes to Avoid

Most scheduling problems come from a handful of avoidable mistakes. Recognizing them is most of the fix, because each has a clear alternative. The thread connecting them is treating scheduling as an isolated weekly scramble rather than a repeatable process built on good information.

The mistake that causes the most compounding damage is publishing schedules too late. Beyond the legal risk wherever predictive scheduling laws apply, last-minute schedules make it impossible for employees to plan their lives, which drives dissatisfaction, absence, and turnover.

Survey data on service sector workers puts numbers on it. According to the Shift Project, a research program based at the Harvard Kennedy School and the University of California, 60 percent of those workers get less than two weeks of notice and 66 percent would prefer a more predictable schedule.

Giving people their schedule with real advance notice is one of the highest-return things an employer can do, and it costs nothing but a bit of planning discipline. Pick a set day each week to publish the next schedule, as far ahead as you can manage, and stick to it.

Frequently Asked Questions