---
title: "How to Make a Work Schedule in Excel — Griddy"
description: "Build a weekly work schedule in Excel that shows shifts, hours, off days, and coverage gaps before the schedule goes out to the team."
canonical_url: "https://getgriddy.ai/blog/how-to-make-a-work-schedule-in-excel/"
---

[Blog](https://getgriddy.ai/blog/)/Excel

Excel

# How to Make a Work Schedule in Excel

Build a weekly work schedule in Excel that shows shifts, hours, off days, and coverage gaps before the schedule goes out to the team.

Do this with AI

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)

Start in your browser. Also works with Excel and Google Sheets.

[By Justin Freels](https://getgriddy.ai/about/)/Updated August 20, 2026/5 min read

A work schedule in Excel should be clear enough for managers to review coverage and simple enough for employees to understand without a second explanation. The useful version is a weekly grid with employees down the rows, days across the columns, and hours or shift labels in each cell.

That structure works for restaurants, retail stores, clinics, hotels, salons, and small teams that need a practical rota without scheduling software.

## Start with the week and team details

Put the operating details at the top before you build the grid:

- location or department
- week start date
- manager name
- target coverage or labor-hours goal

Then create one row per employee. Use columns like Employee, Role, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Weekly Hours, and Notes.

That is the same basic structure behind a practical [employee schedule template](https://getgriddy.ai/templates/employee-schedule/).

## Use consistent shift labels

Do not mix free-form notes, times, and abbreviations unless everyone understands them. Pick a small set of labels and use them consistently:

| Label | Meaning |
| --- | --- |
| Open | Opening shift |
| Mid | Midday shift |
| Close | Closing shift |
| Off | Not scheduled |
| PTO | Approved time off |

If you need exact times, put them in the cell the same way every time: `8-4`, `10-6`, or `2-10`. Consistency matters because it makes filtering, counting, and reviewing much easier.

## Calculate weekly hours

If your schedule uses start and end times in separate columns, weekly hours can be calculated directly. If `C2` is a start time and `D2` is an end time, the hours for that shift can be:

fx

`=(D2-C2)*24`

For a compact schedule that uses labels like Open or Close, many managers keep the Weekly Hours column manual. That is acceptable if shifts are standardized and the schedule is reviewed before publishing.

TIP

If overtime is a risk, keep Weekly Hours visible at the far right of the schedule instead of hiding it on another sheet.

## Review coverage before publishing

Before sending the schedule, scan for these problems:

| Issue | What to check |
| --- | --- |
| Thin coverage | Are there enough people on busy days? |
| Missing role | Is the right role scheduled for each shift? |
| Overtime risk | Are any employees over the weekly threshold? |
| PTO conflict | Did approved leave get copied into the schedule? |
| Weekend imbalance | Are the same people always carrying weekends? |

Restaurant teams may need stronger dinner and weekend coverage. Retail teams may need opening and closing accountability. Healthcare offices may need role coverage by appointment volume. The layout stays similar, but the review criteria should match the business.

## Connect the schedule to PTO

A schedule built without a PTO view will miss approved absences. Keep a [vacation tracker](https://getgriddy.ai/templates/vacation-tracker/) nearby so the manager can see who is already out before assigning shifts.

That matters most in small teams, where one approved vacation can change the whole week. Use the PTO sheet for future leave and the weekly schedule for actual shift assignments.

## The Griddy way

Weekly schedules become tedious when managers are copying PTO notes, balancing hours, and checking coverage by hand.

> "Build next week's employee schedule from this team list, keep weekends balanced, and flag any day that looks understaffed"

Griddy can restructure the sheet, add weekly-hour formulas, and turn a rough staff list into a schedule managers can review before publishing.

## Sources

- [Microsoft Support: Schedule staff shifts](https://support.microsoft.com/en-us/teams/shifts/schedule-staff-shifts)
- [U.S. Department of Labor: Work hours](https://www.dol.gov/general/topic/workhours)

Do this with AI

## Turn the instructions into a finished spreadsheet.

Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

Use this on real templates

## Start with a schedule template built for weekly coverage

A work schedule is easiest to maintain when shifts, weekly hours, off days, and PTO conflicts are visible in the same reviewable grid.

[HR](https://getgriddy.ai/templates/hr/)

[HR ### Employee Schedule Plan a weekly staff rota with day-by-day shifts, weekly hours, overtime flags, and a manager snapshot block. Free template for teams, shops, and clinics. Open template](https://getgriddy.ai/templates/employee-schedule/)[HR ### Clinic Employee Schedule & Coverage Planner Plan clinic role coverage, staff availability, shift rules, and weekly assignments in a free four-sheet staffing workbook. Open template](https://getgriddy.ai/templates/employee-schedule-for-clinics/)[HR ### Employee Schedule for Small Business Coordinate a small team across roles, locations, Mon–Sun shifts, weekly hours, open shifts, and coverage review without a heavy scheduling system. Open template](https://getgriddy.ai/templates/employee-schedule-for-small-business/)[HR ### Employee Schedule for Restaurants Assign restaurant kitchen, service, host, bar, dishwasher, and manager shifts across a Mon–Sun coverage grid. Open template](https://getgriddy.ai/templates/employee-schedule-for-restaurants/)[HR ### Employee Schedule for Retail Plan retail staffing in a Mon–Sun Weekly Coverage Grid with shift assignments, weekly hours, and coverage review plus Dashboard and Setup sheets. Open template](https://getgriddy.ai/templates/employee-schedule-for-retail/)[HR ### Vacation Tracker Track PTO balances, upcoming leave, and coverage risk for the whole team in one shared staffing sheet. Keep low balances, approved trips, and summer planning visible without HR software. Open template](https://getgriddy.ai/templates/vacation-tracker/)

[All posts](https://getgriddy.ai/blog/)

Do this with AI

## Ask Griddy to do this for you.

Describe the result in plain English—no formula knowledge required.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

About this guide

Written by Justin Freels, Founder, Griddy.

Updated August 20, 2026/5 min read

Related templates

[HR](https://getgriddy.ai/templates/hr/)

[Employee Schedule](https://getgriddy.ai/templates/employee-schedule/)[Clinic Employee Schedule & Coverage Planner](https://getgriddy.ai/templates/employee-schedule-for-clinics/)[Employee Schedule for Small Business](https://getgriddy.ai/templates/employee-schedule-for-small-business/)[Employee Schedule for Restaurants](https://getgriddy.ai/templates/employee-schedule-for-restaurants/)[Employee Schedule for Retail](https://getgriddy.ai/templates/employee-schedule-for-retail/)[Vacation Tracker](https://getgriddy.ai/templates/vacation-tracker/)
