How do you set up an employee schedule in Google Sheets?
By Al Davies ยท Updated November 9, 2026
Short answer: Open a blank sheet, put days across the top and names down the side, type hours in each cell, add a total with the SUM formula, and share the sheet as view only. The sample below is a three person grooming shop. You do not need an add on.
What are the steps?
- Go to sheets.google.com, open a blank spreadsheet, and name it with the week, such as Schedule Week of Nov 16.
- Type Name in cell A1. Type Mon through Sun in cells B1 to H1. Type Total in cell I1.
- Type each person's name in column A, starting in A2.
- Type the hours each person works in each day. Type 0 for a day off.
- In cell I2, type =SUM(B2:H2). Press Enter. Drag the corner of I2 down to the last name row.
- In the row under the last name, type =SUM(B2:B4) in column B. Drag it across to column I.
- Turn on a warning for over 40 hours (see the next section).
- Click Share. Under General access, choose Anyone with the link, set the role to Viewer, click Copy link, then Done.
What does the finished sheet look like?
The grid holds hours, not times. Put the start and end times in a notes line under the grid, so the numbers stay easy to add.
| Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total |
|---|---|---|---|---|---|---|---|---|
| Kim | 8 | 8 | 0 | 8 | 8 | 0 | 0 | 32 |
| Lee | 0 | 6 | 8 | 0 | 8 | 8 | 0 | 30 |
| Mo | 6 | 0 | 8 | 8 | 0 | 8 | 6 | 36 |
| Day total | 14 | 14 | 16 | 16 | 16 | 16 | 6 | 98 |
Tip: Check by counting: Kim 8 + 8 + 8 + 8 = 32. Lee 6 + 8 + 8 + 8 = 30. Mo 6 + 8 + 8 + 8 + 6 = 36. People add to 32 + 30 + 36 = 98. Days add to 14 + 14 + 16 + 16 + 16 + 16 + 6 = 98. Both ways give 98.
How do you flag anyone over 40 hours?
The U.S. Department of Labor says most hourly staff must get time and a half once they pass 40 hours in a workweek. A color flag shows the problem before you post.
Select the Total cells in column I. Open the Format menu and choose Conditional formatting. A panel opens on the right. Under Format cells if, choose Greater than and type 40. Under Formatting style, pick a red fill, then click Done.
- Select cells I2 to I4.
- Click Format, then Conditional formatting.
- Under Format cells if, choose Greater than.
- Type 40.
- Under Formatting style, pick a red fill and click Done.
How do you add start and end times?
Keep two lines of notes under the grid. One line is the shift key, such as Open = 8 a.m. to 4 p.m. The other line is anything odd this week.
If you want the times inside the grid, use a second tab named Times with the same layout. The hours tab stays clean for adding.
Notes under the grid:
Open = 8 a.m. to 4 p.m. (8 hours)
Mid = 10 a.m. to 4 p.m. (6 hours)
Kim: Mon, Tue, Thu, Fri Open
Lee: Tue Mid, Wed Open, Fri Open, Sat Open
Mo: Mon Mid, Wed Open, Thu Open, Sat Open, Sun Mid
How do you share it so staff see changes?
Click Share. Under General access, choose Anyone with the link and set the role to Viewer. Click Copy link, then Done. Do not give Editor to everyone, or one wrong click can change the grid. Send the link once and tell staff to use the same link every week.
If you want to keep each week, click the down arrow on the sheet tab at the bottom and choose Duplicate. Double click the new tab's name to rename it. Old weeks stay as a record.
Tip: Pick one start day for your workweek and always show it in the file name. That keeps the 40 hour count the same each week.
What breaks in a spreadsheet schedule?
- Someone types over a formula, and a total is wrong.
- Two people edit at once and one change is lost.
- Staff keep a screenshot, not the live link.
- Swaps happen in a text thread, not in the sheet.
- Totals show hours but do not show who is off that day.
Fix the first by protecting the total cells. Fix the rest with one rule: the sheet is the only place that counts. For a swap rule you can copy, see sample shift swap rules. To pull the week out of a chat for good, see ending schedule changes by text.
How do you protect the formulas?
Click the Data menu, then Protect sheets and ranges. A panel opens on the right. Click Add a sheet or range, click Range, and type I2:I5. Click Set permissions, choose Restrict who can edit this range, pick Only you, and click Done. Repeat for B5:H5. Then staff can open the sheet but the totals stay safe.
If you share the sheet as Viewer only, staff cannot edit any cell. Protection matters when you add a second editor, such as a shift lead.
How do you make a new week quickly?
- Click the down arrow on last week's sheet tab.
- Choose Duplicate.
- Double click the copy's tab name and type the new week.
- Clear the hours in B2 to H4 but keep the formulas.
- Type the new hours and check the totals.
Keep the old tabs as a record. If a pay question comes up later, you can see who worked what.
When is a sheet not enough?
A sheet works well for one small team on one site. If you need shifts, swaps and weekly hours in one view that staff open on a phone, look at ShiftGarden. If you want to start on paper first, see the paper method in six steps.
FAQ
How do I make a schedule in Google Sheets for free?
Open a blank sheet, put days across and names down, type hours, and add a SUM total. Sheets is free with a Google account.
What formula adds a person's weekly hours?
Use =SUM(B2:H2) for row 2, then drag it down. It adds Monday through Sunday.
How do I stop staff from changing the schedule?
Share it with the role set to Viewer, so people with the link can read it but not edit it.
How do I flag more than 40 hours?
Use Format, then Conditional formatting, and color any Total over 40. Federal overtime counts hours in a workweek.
Can I put start and end times in the cells?
You can, but they will not add. Keep hours in the grid and times in a notes line or a second tab.
Sources
- Fact Sheet 23: Overtime Pay Requirements of the FLSA, U.S. Department of Labor
- Overtime Pay, U.S. Department of Labor
- Use conditional formatting rules in Google Sheets, Google Docs Editors Help
- Protect, hide and edit sheets, Google Docs Editors Help
- Share files from Google Drive, Google Drive Help
- SUM function, Google Docs Editors Help
Related guides
- How to Make an Employee Schedule: 6 Steps, Sample Week
- Shift Swapping Schedule: One Page of Sample Swap Rules
- Weekly Shift Schedule Template: Free Grid to Print
- How to Share a Work Schedule With Employees Without an App
- How to Move Your Work Schedule Out of the Group Text
Try ShiftGarden to put your week on one page.