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?

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.

NameMonTueWedThuFriSatSunTotal
Kim880880032
Lee068088030
Mo608808636
Day total141416161616698

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.

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?

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?

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

Try ShiftGarden to put your week on one page.