Step 1: Work out how many people you need, and when
Before you think about who works, decide how many people each part of the day needs. Think in time blocks and roles, not names: two on the floor from 9 to 15, one cashier from 10 to 19, one person for the morning delivery.
Use what you already know: sales or foot traffic by hour, the busy days, the tasks that happen at fixed times such as deliveries, opening and closing. Add people for peaks rather than for the whole day.
Example: the Retail store preset below needs 273 staff-hours a week. At 32 hours per person that is at least 10 people, before anyone takes time off. Change the numbers to your own and the totals update.
Coverage template
Example — edit to match your place.
| Role | Shift | Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
|---|---|---|---|---|---|---|---|---|---|
- Sales associate — 180 staff-hours / week · 6 people minimum
- Cashier — 81 staff-hours / week · 3 people minimum
- Stock — 12 staff-hours / week · 1 people minimum
Total: 273 staff-hours / week · 10 people minimum
Minimum headcount, before time-off and sick days.
Steps 5 to 7 are where the hours go. Smeno does them for you: describe your team, shifts and rules in plain English, and it assigns everyone, checks the rules and flags gaps. Free.
Step 2: Turn coverage into shifts
Group the blocks into shifts people can actually work. Four to eight hours is typical for retail and hospitality. Overlap shifts by 30 to 60 minutes where handover matters, so the store is never empty at the change.
In the example, the floor runs on two six-hour shifts, 9 to 15 and 14 to 20, with an hour of overlap during the afternoon peak.
If you run around the clock, look at rotating patterns such as DuPont or 2-2-3 instead of building shifts by hand.
Step 3: Collect availability and time-off
Ask everyone for availability and time-off requests by a fixed date, in one place. A shared form or sheet beats requests scattered across chats.
Separate hard limits from preferences. "Can't work Sundays" is a limit you must respect. "Prefer mornings" is a preference you meet when you can.
Step 4: Write down your rules
Rules that live only in your head get broken when you are in a hurry. Write them down before you assign anyone:
- Maximum hours per week. Federal law requires overtime pay after 40 hours in a workweek, and California also counts overtime after 8 hours in a day.
- Minimum rest between shifts, for example 10 or 11 hours, so nobody closes and then opens.
- Maximum days in a row and how many weekends each person works per month.
- Who can work which role, and who should not be scheduled together.
- Breaks, if your state requires them.
Step 5: Assign people to shifts
Fill the hardest shifts first: weekends, closings and roles only one or two people can do. Then fill the rest, checking each person's hours against your rules as you go.
Rotate the unpopular shifts instead of giving them to whoever complains least. Keep a tally of weekends and closings per person, so you can show who got what.
Step 6: Post the schedule early
Post at least a week ahead, two if you can. In places with fair workweek laws, such as Oregon, New York City, Chicago and Seattle, covered employers must post 14 days ahead.
Use one channel everyone checks, and make sure each person can see their own shifts without scrolling through everyone else's.
Step 7: Handle swaps and changes
Decide the swap rule once: who approves, and whether the person taking the shift has to be trained for the role. Keep a short list of people willing to pick up extra shifts.
After every change, check the rules again. A swap can quietly create a clopen or push someone past 40 hours.
Excel or a scheduling app?
A spreadsheet works for a small team with fixed shifts. Put people or roles in rows and days in columns, and sum hours in the last column. The template above copies straight into Excel or Google Sheets.
Spreadsheets start to hurt when the rules pile up: time-off, rest between shifts, weekly limits and roles all have to be checked by eye, and every sick call means redoing part of the grid. That is the point where a scheduling app pays off.
FAQ
How do I make a work schedule in Excel?
List people or roles in rows and the days of the week in columns, write shift times in the cells, and add a column that sums weekly hours. Or set your coverage in the template above and use Copy as table to paste it into Excel or Google Sheets.
How far in advance should I post a work schedule?
One to two weeks is common practice. Federal law sets no deadline, but covered employers in Oregon, New York City, Chicago and Seattle must post schedules 14 days ahead.
How do I make a fair work schedule?
Rotate weekends, closings and holidays, track how many each person gets, balance weekly hours, and respect hard availability limits before preferences. Posting early also counts as fairness, because people can plan their lives.
How many hours can an employee work in a week?
Federal law sets no weekly limit for adults, but hours over 40 in a workweek must be paid as overtime. Some states add daily overtime, and federal law limits the hours of workers under 16.
What should a work schedule include?
Dates, each person's name and role, shift start and end times, and breaks where required. Add who to contact for swaps and the date the schedule was posted.
See also
Sources
- U.S. Department of Labor: Fact Sheet #23, Overtime pay requirements of the FLSA
- California Labor Commissioner: Overtime FAQ
- U.S. Department of Labor: Breaks and meal periods
- U.S. Department of Labor: YouthRules (hour limits for workers under 16)
- Oregon Bureau of Labor and Industries: Predictive scheduling
- NYC Department of Consumer and Worker Protection: Fast food worker rights
- City of Chicago: Fair Workweek
- Seattle Office of Labor Standards: Secure Scheduling