Employee Work Schedule Template for Google Sheets

To make an employee work schedule template in Google Sheets, create a spreadsheet with columns for date, employee, start time, end time, unpaid break, hours, role, and location. Add one row for each employee’s shift, then use a formula to calculate hours and share the sheet with the people who need it.

What an employee schedule template should include

A useful schedule makes it easy to answer three questions: who is working, when are they working, and where or in what role? A basic template can use these columns: Date, Employee, Start, End, Unpaid break (minutes), Paid hours, Role, Location, and Notes. Add a row for every shift rather than trying to fit several employees and shift details into one cell.

For example, a café might have one row for Jordan’s Tuesday opening shift and another for Priya’s Tuesday afternoon shift. The role column could say “barista” or “shift lead,” while Notes can hold a concise handoff detail. Keep personal or sensitive employee information out of a schedule that many staff members can view.

Some teams also need a status column, such as Draft, Published, or Change requested. This is useful when a schedule is still being prepared, but avoid using color alone to communicate status; include readable text as well.

Build the sheet in Google Sheets

In a web browser, open Google Sheets and choose Blank spreadsheet. Give the file a clear name, such as “Weekly Staff Schedule,” and add a separate tab for each week or scheduling period if that suits the team. A single tab with a date column can work better when managers need to filter across several weeks.

Enter the column headings in row 1. Freeze that row with View > Freeze > 1 row so headings stay visible while scrolling.
Enter each shift on its own row. Use actual date and time values in the Date, Start, and End columns, not text that only looks like a date or time.
Set the date and time display using Format > Number > Date and Format > Number > Time. Choose a display style that your team can read consistently.
Use Data > Create a filter to let viewers filter by date, employee, role, or location. Avoid sorting only one column, which can detach names from their shifts.
Test the layout with a few sample shifts before entering the full schedule. Check both a weekday shift and any overnight shift your business uses.

Google Sheets saves changes as you work when you are online. If a team already has a schedule file, use File > Make a copy before making substantial edits so the previous version remains available.

Choose a layout that fits the team

A shift-by-row table is generally the most flexible starting point. It is easy to filter, sort, extend with new dates, and summarize with formulas. It also avoids a common problem with calendar-style grids: a narrow cell may not have room for several employees, roles, or shift notes.

A weekly grid can be easier to scan at a glance. For example, place employees down the left side and days of the week across the top, with each cell showing a shift such as “9:00 AM–5:00 PM.” This is visually familiar, but it can be less convenient for calculating hours or filtering by role. If you use a grid, keep a structured shift table on another tab as the source of truth, or make sure each scheduled shift is recorded consistently.

Small team with one location: A weekly grid may be enough if shifts are simple and there are few changes.
Multiple roles or locations: Use one shift per row with separate Role and Location columns.
Several managers editing: Keep a structured table, label the schedule period clearly, and agree on how edits are recorded.

Calculate shift hours and weekly totals

For the table described above, assume Start is in C, End is in D, Unpaid break minutes is in E, and Paid hours is in F. With the first shift in row 2, enter =(MOD(D2-C2,1)*24)-(E2/60) in F2 and fill it down. For a 9:00 AM to 5:30 PM shift with a 30-minute unpaid break, the result is 8 hours: 8.5 elapsed hours minus 0.5 break hours.

MOD handles a shift that crosses midnight: a 10:00 PM to 6:30 AM shift has 8.5 elapsed hours before breaks. With a 30-minute unpaid break in E2, the same formula returns 8. The formula assumes the cells contain valid time values and that the break is entered as minutes. Confirm whether a break should be deducted under the employer’s policy and applicable requirements; do not treat the formula as a rule about paid time.

To total an employee’s scheduled hours, assume employee names are in B2:B100, paid hours are in F2:F100, and the employee to summarize is entered in K2. Put =SUMIF(B2:B100,K2,F2:F100) in another cell. If K2 contains Maya and her listed shifts total 24.5 hours, the result is 24.5. Extend the ranges if the schedule grows, and check that names are spelled consistently so the total does not omit a shift.

These formulas calculate scheduled hours; they do not determine overtime eligibility, payroll deductions, or whether a shift complies with local rules. Those questions depend on the applicable policy and jurisdiction.

Make the schedule readable and reduce mistakes

Use straightforward formatting rather than relying on decoration. Bold the heading row, apply a contrasting fill, and use Format > Conditional formatting for helpful visual cues such as highlighting shifts on a selected date or flagging blank entries. Since custom conditional-formatting rules can be easy to misconfigure, test them on a sample row before relying on them.

For columns such as Role or Location, a dropdown can help standardize entries. In Google Sheets, select the cells and choose Insert > Dropdown, then enter the permitted options. A dropdown reduces variations such as “Front desk,” “frontdesk,” and “Front Desk,” which can make filtering less reliable.

Use a consistent time format and include AM or PM where the display could be ambiguous.
Keep dates in a real date column; do not use headings like “Monday” as the only date record.
Use notes for exceptions, not as a substitute for the start and end time.
Check the sheet at a normal viewing size and on a phone if employees commonly check schedules on mobile devices.

Sharing, permissions, and schedule changes

Choose Share in the upper-right corner to invite specific people or set link access. For a schedule containing employee names and work details, sharing with named accounts is usually more controlled than making the file available to anyone with the link. Give edit access only to people responsible for maintaining the schedule; employees who only need to view it can receive Viewer access.

Google Sheets supports concurrent editing, but collaboration does not replace a clear change process. Decide who publishes the schedule, where staff should report a conflict, and how last-minute changes are confirmed. A Notes or Change log tab can record the date of a change and a brief description. Avoid putting private reasons for absences or medical details in a shared schedule.

Google account and Workspace administrators may have different sharing settings, so available access choices can depend on the account. Review who can open the file periodically, especially when staff or managers leave. A spreadsheet link can be forwarded, so link access should not be treated as a guarantee that only the intended person will see the schedule.

Common scheduling problems to check

Before publishing, check for overlapping shifts, missing end times, accidental duplicates, and employees assigned to the wrong location. A filter can help inspect one employee or date at a time, but a visual review is still important. If two people share a name, use a consistent identifier such as a work email in a private administrative column, while limiting who can see it.

Also check whether the schedule crosses a week boundary or midnight. A shift beginning late Sunday and ending Monday may need to be assigned according to the organization’s chosen reporting convention. Daylight saving time changes can make overnight durations more complicated than an ordinary subtraction; verify those shifts rather than assuming a simple displayed-time difference always represents elapsed clock time.

Finally, do not assume a spreadsheet prevents every staffing conflict. Google Sheets will not automatically know an employee’s availability, qualifications, approved leave, or local scheduling restrictions unless the team records and checks those factors. A manager should review the completed roster against the relevant records and policies before publishing it.

Google Sheets compared with other scheduling options

Google Sheets is a practical choice when a team needs an editable shared roster, basic calculations, and a familiar browser-based tool. It can be adapted without installing a dedicated scheduling system, and people with appropriate access can view the current version. Google Sheets is available without charge for personal Google accounts; organizations using Google Workspace may pay according to their plan. Account features and administrative controls can vary, so check the current plan details rather than assuming every organization has the same setup.

A spreadsheet requires more manual upkeep than dedicated workforce scheduling software. Such systems may offer features like availability collection, shift notifications, time-off workflows, or links to timekeeping, depending on the product and plan. Those features should not be assumed in a Google Sheets template. Excel can also hold a shift table and formulas, but its sharing and interface differ; this template’s menu paths and instructions are for Google Sheets in a web browser, not Excel.

For a small team with predictable shifts, a spreadsheet may be sufficient. If schedules change frequently, the team has many locations, or managers need automated notifications and approval workflows, compare purpose-built tools and consider whether their cost and setup are justified.

Frequently Asked Questions

Does Google Sheets have a free employee schedule template?
Google Sheets has a template gallery that may offer schedule-related starting points, though the available templates can change. You can also create the table described here in a blank spreadsheet. Review any downloaded or copied template before entering staff information.

How do I make a weekly work schedule in Google Sheets?
Create columns for date, employee, start, end, break, and role, then enter one shift per row. Add a filter and, if needed, a weekly-hours formula. A calendar-style grid is another option for a simple team, but a shift table is easier to summarize and filter.

Can Google Sheets calculate hours for an overnight shift?
Yes. With start time in C2, end time in D2, and unpaid break minutes in E2, =(MOD(D2-C2,1)*24)-(E2/60) calculates elapsed hours minus the entered break. Check the result for shifts affected by daylight saving time.

How can employees view the schedule without editing it?
Use Share and give those employees Viewer access, or share with named accounts under your organization’s access rules. Keep editing rights limited to the people who maintain the roster.

Is a Google Sheets schedule suitable for payroll or legal compliance?
It can help organize planned shifts, but a schedule is not necessarily a time record and its formulas do not establish payroll or legal compliance. Check actual worked time, employer policies, and applicable requirements with qualified sources.

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.