Employee scheduling spreadsheet for multiple locations (free template)
A free employee scheduling spreadsheet for multiple locations works best as one shift list for every store (date, location, employee, start, end, break) plus a summary tab that totals each person's hours across all stores. The cross-store total matters because FLSA overtime is owed for hours over 40 in a workweek, and a person's shifts at all your stores are hours worked for you.
Tab 1: the shift list (one row per shift)
| A: Day | B: Location | C: Employee | D: Start | E: End | F: Unpaid break (min) | G: Paid hours | H: Overlap? |
|---|---|---|---|---|---|---|---|
| Mon | Store 1 | Maria | 9:00 | 17:00 | 30 | 7.5 | FALSE |
| Tue | Store 2 | Maria | 10:00 | 18:00 | 30 | 7.5 | FALSE |
| Wed | Store 1 | Maria | 9:00 | 17:00 | 30 | 7.5 | FALSE |
| Thu | Store 3 | Maria | 12:00 | 20:00 | 30 | 7.5 | FALSE |
| Fri | Store 2 | Maria | 9:00 | 17:00 | 30 | 7.5 | FALSE |
| Sat | Store 1 | Maria | 10:00 | 16:00 | 0 | 6 | FALSE |
| Tue | Store 2 | James | 12:00 | 16:00 | 0 | 4 | TRUE |
| Tue | Store 3 | James | 15:00 | 19:00 | 0 | 4 | TRUE |
Formulas for row 2, filled down (Google Sheets and Excel):
- G2 paid hours: =(E2-D2)*24-F2/60. Check: 9:00 to 17:00 is 8 hours, minus 30 ÷ 60 = 0.5, gives 7.5.
- H2 overlap: =COUNTIFS(C:C,C2,A:A,A2,D:D,"<"&E2,E:E,">"&D2)>1. It counts shifts for the same person on the same day that start before this one ends and end after it starts. James's two Tuesday shifts overlap from 15:00 to 16:00, so both rows show TRUE.
For a dated schedule, put the date in column A instead of the day name, so the overlap check does not match the same weekday in different weeks.
Tab 2: weekly hours per person, all stores
| A: Employee | B: Store 1 | C: Store 2 | D: Store 3 | E: Total | F: Over 40 |
|---|---|---|---|---|---|
| Maria | 21 | 15 | 7.5 | 43.5 | 3.5 |
| James | 0 | 4 | 4 | 8 | 0 |
- B2: =SUMIFS(Shifts!$G:$G,Shifts!$C:$C,$A2,Shifts!$B:$B,B$1), filled right and down (the tab is named Shifts; row 1 holds the store names) (type only the store name in row 1, e.g. Store 1)
- E2: =SUM(B2:D2); F2: =MAX(0,E2-40)
Example: Maria's Store 1 hours are 7.5 + 7.5 + 6 = 21, Store 2 is 7.5 + 7.5 = 15 and Store 3 is 7.5, for 43.5. No single store shows more than 21 hours, but she has 3.5 overtime hours. At $17 an hour: 40 × $17 = $680 plus 3.5 × $25.50 = $89.25, for $769.25. Check other rates with the overtime calculator.
Where the spreadsheet breaks
| Breaking point | What goes wrong | Workaround in the sheet |
|---|---|---|
| Two managers edit separate copies | Shifts in one copy are missing from the cross-store total | One shared file; each manager edits only their store's rows |
| Time off arrives by text | A shift lands on an approved day off | A Time off tab (employee, date) and a COUNTIFS check in column I |
| Planned vs. worked hours | The sheet holds the plan; Fact Sheet #21 requires hours actually worked each day and each workweek | Record actual in and out times for each shift; Fact Sheet #21 allows exception-only records only for employees on a fixed schedule from which they seldom vary. |
| Minors on the schedule | No check against under-16 limits | A birth-date column (required for anyone under 19) and a weekly cap check; see rules for scheduling minors |
| Old weeks overwritten | Work and time schedules must be kept 2 years, payroll records 3 years | Save a dated copy of every published week |
The FLSA requires no particular form for records and accepts any timekeeping method that is complete and accurate (Fact Sheet #21), so a spreadsheet is allowed. For a single-store grid layout, see the retail store weekly schedule template.
When the shift list outgrows the file, Assistlify builds the weekly schedule with staff assigned to one or more locations and checks time off against shifts; you add your stores and staff yourself, with a setup consultation call if you have questions; see multi-location scheduling.
This is general information, not legal advice. Check your state labor department for current rules.
This is general information, not legal advice. Check your state labor department for current rules.
Questions
Is there a free spreadsheet template for scheduling multiple locations?
Yes: use one shift list with date, location, employee, start, end and break columns, and a SUMIFS summary that totals each person's hours across all stores.
Can I keep employee hours in a spreadsheet?
Yes; US DOL Fact Sheet #21 says the FLSA requires no particular form, as long as hours worked each day and each workweek are complete and accurate.
How long do I have to keep old work schedules?
Fact Sheet #21 says work and time schedules and time cards are kept 2 years and payroll records 3 years.
How do I count overtime for someone who works at two stores?
Add their paid hours at every store in the same workweek; 21 + 15 + 7.5 = 43.5 hours means 3.5 overtime hours.
Sources
- US DOL Fact Sheet #23: Overtime Pay Requirements of the FLSA (revised October 2019) (checked 2026-11-12)
- US DOL Fact Sheet #21: Recordkeeping Requirements under the FLSA (revised July 2008) (checked 2026-11-12)
- US DOL: Selected State Child Labor Standards (as of July 15, 2025), Federal (FLSA) row (checked 2026-11-12)