Employee Schedule Template for Google Sheets: Setup

An employee schedule template in Google Sheets is a reusable spreadsheet for assigning shifts, tracking hours, and sharing the rota with a team. You can start with a blank sheet in a browser, add employee and shift details, then use a simple hours formula and filters to make the schedule easier to manage.

What an employee schedule template should include

A useful template makes it clear who is working, when each shift starts and ends, and where staff can find the latest version. The right layout depends on the workplace: a small shop with fixed weekly hours needs less detail than a restaurant that changes shifts every day. Begin with the information managers and employees actually need, rather than adding every possible field.

For a basic weekly rota, use one row per shift and columns such as:

Employee name and, if needed, role or team.
Shift date, start time, and end time.
Unpaid break duration and calculated paid hours.
Location or station when employees may work in more than one place.
A notes field for approved changes, coverage needs, or other scheduling details.

One row per shift is generally easier to sort and filter than a large grid with employee names down the side and a different set of columns for every day. A weekly grid can be quicker to read on a wall or screen, but it becomes awkward when people have multiple shifts in one day or when the schedule covers several locations. Choose the format based on how the schedule will be used, not just how it looks when empty.

Create the schedule in Google Sheets

Open Google Sheets in a web browser and create a blank spreadsheet. You can also open an existing file and use File > Make a copy to preserve the original before adapting it. Template options may vary by account or organization, so a blank sheet is a reliable starting point if you do not see a suitable schedule in the template gallery.

Give the file a descriptive name, such as “Store Team Schedule – Week of May 4.” Avoid putting sensitive personal information in the filename.
Enter the column headings in row 1. For a shift-by-shift layout, use Employee, Date, Start, End, Unpaid break (hours), and Paid hours.
Freeze the heading row using View > Freeze > 1 row so the labels remain visible while scrolling.
Set the Date column to a date format and the Start and End columns to a time format. Select the cells, then use Format > Number and choose an appropriate date or time option.
Add shifts below the headings, with each employee’s shift on its own row. Keep the same column meaning throughout the sheet.

Enter dates as dates rather than typing a weekday name alone. A real date can be sorted, filtered, and used in weekly calculations; a text label such as “Monday” cannot reliably distinguish one week from another. Likewise, enter start and end times as time values. A value that only looks like a time but is stored as text may not calculate correctly.

Calculate paid hours accurately

A formula can calculate the duration of each shift, subtracting an unpaid break. For the following example, employee names are in A2:A, dates in B2:B, start times in C2:C, end times in D2:D, unpaid break lengths in hours in E2:E, and calculated hours in F2:F. Put the formula in F2 and fill it down. If a shift runs from 9:00 a.m. to 5:00 p.m. with a 0.5-hour unpaid break, the result is 7.5 paid hours.

=IF(OR(C2="",D2=""),"",MOD(D2-C2,1)*24-E2)

The MOD calculation also handles an overnight shift, provided the start and end are entered as times on the same row. For example, 10:00 p.m. to 6:00 a.m. is eight elapsed hours; subtracting a 0.5-hour break returns 7.5. This formula assumes breaks are entered in decimal hours: 30 minutes is 0.5, not 30. If your workplace records breaks in minutes, convert them consistently or adapt the calculation. Format the result column as a number, such as two decimal places, rather than as a clock time.

This calculation is a planning aid, not a determination of legally payable time. Rules about breaks, rounding, overtime, and recordkeeping vary by location and circumstance. Confirm the applicable requirements with an appropriate professional or official source, and do not treat a spreadsheet total as a substitute for payroll review.

Summarize weekly hours by employee

A weekly total helps a manager spot a schedule that may need review. Suppose the shift data uses the columns above, H2 contains an employee’s name, and I1 contains the first date of the week. Enter this formula in the summary cell and use a valid date in I1. It adds that employee’s hours from the start date through the six following days.

=SUMIFS($F$2:$F,$A$2:$A,$H2,$B$2:$B,">="&$I$1,$B$2:$B,"<"&$I$1+7)

With the employee in H2 scheduled for 7.5 hours on Monday and 8 hours on Tuesday in the selected week, the formula returns 15.5. The less-than condition at the end of the date range avoids including a shift on the following Monday. Make sure the dates in column B and the week-start value in I1 are genuine date values, and check that the summary name matches the spelling in column A. A formula cannot fix inconsistent names such as “Alex R.” in one row and “Alex Rivera” in another.

Make the sheet easier to read and update

Use formatting to help people scan the rota, not to encode information that only the creator understands. Bold the heading row, apply a restrained fill color, and widen columns so dates, names, and times are legible. Format > Wrapping can help with longer notes, but keep the main schedule columns concise so the sheet does not become difficult to view on a phone.

Google Sheets can highlight scheduling conditions with Format > Conditional formatting. For instance, you can give different roles distinct colors or highlight blank required cells. Explain the color key near the schedule; color alone may be difficult for some readers to distinguish and should not be the only way a critical status is communicated. Use Data > Data validation to provide a controlled list for fields such as role or location when consistent entries matter. Validation can reduce spelling differences, but it does not prove that an assignment is correct.

Filters are useful when the schedule contains many employees or dates. Select the header row or schedule range and choose Data > Create a filter. A manager can then display one employee, date, or role without deleting other rows. Avoid sorting just one column by itself: that can separate names from their shift details. Sort the complete table or use its filter controls.

Share the schedule without losing control

Google Sheets is useful for a shared rota because changes can be made in the same cloud-based file, rather than circulating multiple email attachments. Use the Share button to invite specific people and choose whether each person can edit, comment, or view. A manager who assigns shifts may need edit access; most employees who only need to check their shifts need view access. The appropriate settings depend on the organization’s account and sharing policies.

Before sharing, check the file’s general access setting and the list of people with access. A link that allows broad access can expose the schedule beyond its intended audience. Schedules may reveal work patterns or contact information, so include only information needed to arrange work. Do not add private details such as medical information or personal identifiers just because the spreadsheet has spare columns.

For a clearer handoff, include the week covered and the date it was last updated. Agree on a process for changes: for example, employees request a shift swap and a manager updates the shared schedule after approval. A spreadsheet shows the current entries, but it does not automatically create a reliable approval or notification process. Staff should know where the official schedule lives and how they will be told about a change.

Common problems and practical checks

Hours appear wrong: Check that start and end values are stored as times, breaks use the expected unit, and the formula was filled into every shift row. A break entered as 30 in a formula expecting hours will subtract 30 hours.
Overnight shifts look negative: A straightforward end-minus-start calculation can produce a negative duration when the shift crosses midnight. The MOD-based example above handles that pattern, but verify it against your time-entry conventions.
Weekly totals omit a shift: Check the week-start date, the employee spelling, and whether the shift date is a true date value. Also confirm that the hours cell contains a number rather than text.
Edits overwrite formulas: Keep calculated columns separate from manually entered fields and tell editors which cells they should change. If appropriate for your account and workflow, Data > Protect sheets and ranges can restrict editing; protection is not a replacement for careful sharing permissions.
Two versions circulate: Keep one shared source of truth and send a link to it instead of repeatedly attaching downloaded copies. If a static copy is needed for printing, label it with the date so readers know it may not reflect later changes.

A quick review before publishing can catch many avoidable issues. Scan for unassigned shifts, duplicate entries, missing dates, implausible hours, and employees scheduled at overlapping times. A spreadsheet can flag or display data, but someone still needs to decide whether the coverage is sensible and whether the entries reflect approved assignments.

Google Sheets compared with other scheduling options

Google Sheets is a practical choice when the schedule is relatively simple, a team already uses Google accounts, and a manager is comfortable maintaining the file. It offers a flexible layout and basic formulas without requiring a dedicated scheduling system. However, it does not by itself provide the full workflow of a specialized workforce platform. Features such as automatic availability collection, shift-swap approvals, reminders, labor forecasting, and payroll integrations depend on other tools or manual processes.

Excel can also hold a schedule, and many basic formulas and spreadsheet concepts work in both products. The menus, sharing behavior, and some collaboration details differ, so instructions written for Google Sheets should not be assumed to match Excel exactly. A dedicated scheduling app may suit a larger operation with complex rules, multiple locations, or frequent shift changes, but compare its capabilities, data handling, and price with the actual needs of the organization before switching.

Cost and ongoing maintenance

Google Sheets is available through Google accounts, while features and administrative controls can depend on whether the account is personal or part of a paid Google Workspace plan. Workspace pricing and included features can change, so check Google’s current plan information rather than relying on an old price quoted elsewhere. A schedule made in Sheets can still carry indirect costs: someone must prepare it, check hours, resolve conflicts, and communicate changes.

Maintenance is easier when a new week can be created from a clean copy of the template, with formulas and headings preserved. Before reusing it, update the week dates, clear only the old shift entries, and confirm that formulas remain in calculated columns. Keep a separate master template so a manager does not accidentally erase the structure while clearing last week’s rota. If the team grows or manual coordination becomes burdensome, that is a useful point to compare spreadsheet upkeep with a scheduling tool.

Frequently Asked Questions

Does Google Sheets have an employee schedule template?
Google Sheets may show templates in its template gallery, but the options can vary. If none fits your needs, create a blank spreadsheet with employee, date, start, end, break, and hours columns, then save a clean copy as your reusable template.

How do I make a weekly employee schedule in Google Sheets?
Create headings for each shift detail, enter one shift per row, and use dates and time values rather than typed labels. Add filters if the schedule is long, check totals, and share the file with access limited to the people who need it.

Can Google Sheets calculate shift hours automatically?
Yes. A formula can subtract a start time from an end time and subtract an unpaid break, including an overnight shift when the calculation accounts for crossing midnight. Confirm that the time values and break units match the formula’s assumptions.

Can employees edit their own schedule?
They can if they have edit access, but unrestricted editing can cause accidental changes to assignments or formulas. Many teams give employees view access and route correction or swap requests through a manager who updates the official sheet.

Is a Google Sheets schedule suitable for payroll?
It can help estimate or summarize scheduled hours, but scheduled time is not necessarily the same as time actually worked or payable. Verify actual time records and applicable payroll rules before using totals for payroll decisions.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.