Employee Shift Schedule Template: Free Excel Guide

How-to basics · Updated November 22, 2026

Yes. You can make a free employee shift schedule in Excel by starting with a blank workbook or an available schedule template, then listing each shift, employee, date, start time, end time, and unpaid break. A simple hours formula can total paid shift time, while filters and formatting make the schedule easier to use.

Where to find a free Excel schedule template

In Excel for Microsoft 365 on Windows, open Excel and choose New. Search the template gallery for terms such as schedule or employee schedule; the available choices can vary by account, region, and time. You can also start with a blank workbook. A template is a starting point, not a guarantee that its layout, formulas, or rules fit your workplace, so check it before relying on its totals.

Excel for the web can be used at no charge with a Microsoft account, while access to the desktop Excel app depends on your license. If you find a workbook online, download it only from a source you trust, and inspect its formulas and any macros before entering staff information. A plain workbook you create yourself is often easier to adapt than a complex file designed for a different business.

Choose a layout that matches the work

For a small team, a weekly grid with employees down the rows and days across the columns is quick to scan. It works well when each person has one shift per day. For more varied schedules, use a shift log with one row per shift. That format handles split shifts, multiple locations, and employees who work different roles on the same date more cleanly.

A practical shift-log layout uses these columns:

  • Employee: the staff member’s name or a unique employee ID.
  • Role and location: useful when one schedule covers different duties or sites.
  • Shift date: enter a real Excel date, not text that only looks like a date.
  • Start and end: enter times as Excel times, such as 9:00 AM and 5:00 PM.
  • Unpaid break minutes: enter the break duration as a number, such as 30.
  • Paid hours and notes: calculate hours and record relevant handover or coverage details.

Use one row per shift and put headings in row 1. For example, the first employee’s shift goes in row 2, with the employee in A2, date in C2, start in D2, end in E2, break minutes in F2, and paid hours in G2. Keep names consistent: typing “Sam Lee” in one row and “S. Lee” in another can make totals split across two entries.

Build the schedule step by step

  1. Open a blank workbook and enter the column headings in row 1. Keep the headings short and specific.
  2. Enter one row for each shift. If an employee works two separate shifts in a day, make two rows rather than combining them.
  3. Format the date column as a date and the start and end columns as times. In Excel for Windows, select the cells and use Home > Number to choose an appropriate format. The Mac ribbon has the same basic number-format controls, though the interface may look different.
  4. Enter the paid-hours formula in the first data row, then fill it down for the shifts you add.
  5. Use filters to find a particular employee, date, role, or location. Select the heading row and choose Data > Filter.
  6. Set the date range for the week, review coverage, and save a copy with a clear name, such as Team Schedule – Week of 3 November.

Keep the schedule’s date range visible near the top of the sheet, especially if staff will print it or view it on a phone. A title such as “Week starting Monday, 3 November” reduces confusion when an old schedule is still open in someone’s browser or inbox.

Calculate paid hours accurately

With employee in A2, date in C2, start time in D2, end time in E2, unpaid break minutes in F2, and paid hours in G2, enter this formula in G2:

=IF(OR(D2="",E2=""),"",MOD(E2-D2,1)*24-F2/60)

Format G2 as a number, for example with one decimal place. A shift from 9:00 AM to 5:00 PM is eight hours; subtracting a 30-minute unpaid break gives 7.5 paid hours. The MOD calculation also handles a shift that crosses midnight: 10:00 PM to 6:00 AM is eight elapsed hours before any break is deducted. Copy the formula down the column for additional shifts.

This is a scheduling calculation, not a payroll or compliance determination. The break entry assumes the break is unpaid and should be deducted from the shift. If that assumption is wrong for a particular shift, enter the appropriate break value or adjust the workbook’s design. Review negative results, unusually long shifts, missing times, and breaks longer than the shift rather than treating every calculated number as correct.

To total an employee’s scheduled hours for a week, assume employee names are in A2:A100, dates in C2:C100, and paid hours in G2:G100. Put the employee to summarize in J2 and the week’s first date in L1, then use this formula in a summary cell:

=SUMIFS($G$2:$G$100,$A$2:$A$100,J2,$C$2:$C$100,">="&$L$1,$C$2:$C$100,"<"&$L$1+7)

If J2 contains an employee with five 7.5-hour shifts dated within that seven-day period, the result is 37.5. The formula includes dates from the week-start date through the day before the following week. It groups a shift by its start date; it does not divide an overnight shift between two calendar days. Extend the ranges if your schedule grows beyond row 100.

Make the workbook easier to read and update

Clear formatting helps people spot mistakes before a shift begins. Use a consistent time format, bold the heading row, and apply a restrained color to distinguish dates or roles. Avoid relying on color alone to communicate that a shift is urgent or unfilled; include a text status such as Open or Confirmed so the meaning remains clear in print and for readers who cannot distinguish the colors.

In Excel for Microsoft 365 on Windows, select the schedule range and choose Home > Format as Table to apply a table style and make filtering easier. Choose a style with readable contrast. To highlight blank or unusual entries, use Home > Conditional Formatting; set rules that match the workbook’s needs and test them on sample rows. Do not assume a colored cell proves that a shift is covered or that a total is valid.

For a printed copy, check print preview and set the page orientation to landscape if the columns do not fit. Use Page Layout > Orientation > Landscape in the Windows desktop ribbon. On Mac, use the Page Layout controls if available or the print dialog’s page setup options. Keep the employee names and date headings visible on every printed page where practical, and avoid shrinking the sheet until the text is difficult to read.

Choose the right level of detail

The best template depends on how schedules are assigned and reviewed. A compact weekly grid is easiest when shifts are predictable and the team is small. A row-per-shift log is better for changing start times, multiple roles, or records that need filtering by date. A monthly calendar gives a broad view of time off and coverage, but it can be awkward for calculating hours unless shifts are also recorded in a structured table.

  • Choose a weekly grid when staff mainly need to see who works each day.
  • Choose a shift log when you need dependable filtering and hour totals.
  • Choose a calendar view when seeing patterns across several weeks matters more than detailed calculations.
  • Use separate sheets or workbooks when locations or departments need different access or substantially different layouts.

Whichever layout you choose, make the schedule’s purpose clear. A planning sheet may show proposed shifts; a published schedule should show confirmed shifts and the date it was last updated. If a change is made after publication, notify the affected employees through the agreed channel rather than assuming they will notice a changed cell.

Common scheduling spreadsheet problems

One frequent issue is entering times or dates as text. A value that looks like 9:00 AM may not behave as a time if it was pasted with an unexpected format. Test a sample calculation and check the number format if hours do not calculate. Another issue is inconsistent employee names, which causes filters and summary totals to miss some rows. A staff list or consistent employee ID can reduce that risk.

Also check for overlapping shifts, uncovered opening or closing periods, duplicate rows, and accidental edits to formula cells. A schedule can show total hours without confirming that every role is staffed at the right time. Review coverage separately, especially when a minimum number of staff or a particular qualification is needed.

Scheduled hours are not necessarily actual hours worked. Late arrivals, shift swaps, call-outs, and early departures can make the final hours differ. Keep approved schedule changes clear, and use the appropriate timekeeping process for actual attendance. Rules about breaks, rest periods, overtime, and recordkeeping depend on the relevant location and circumstances; verify applicable requirements with an authoritative source or qualified professional rather than treating a template as legal guidance.

Excel template or scheduling software?

A spreadsheet is a reasonable choice when one person maintains a modest schedule, staff can receive updates reliably, and the business does not need automated shift swaps or notifications. It is flexible, familiar, and easy to tailor. The main cost may be access to desktop Excel or the time spent maintaining the file; a basic workbook does not itself provide a secure employee self-service system.

Dedicated scheduling software may be more suitable when many managers edit schedules, employees need to request swaps, or the organization needs notifications, availability tracking, or integrations with timekeeping. These products may charge fees and require setup, so compare current pricing and features before choosing. A spreadsheet remains useful for planning or exporting data, but it becomes harder to control when several copies circulate and edits are not coordinated.

Sharing and protecting the schedule

Store one authoritative workbook in a location your team is permitted to access, and make clear which version is current. Excel for the web supports sharing a workbook through OneDrive or SharePoint, subject to account and organization settings. In the desktop app, use the Share button when the file is stored in a supported cloud location. Menu wording and available sharing options can differ on Mac and in managed work accounts.

Give people only the access they need, and avoid including sensitive personal details that are unnecessary for scheduling. Sheet protection can help prevent accidental changes, but it is not a substitute for secure file permissions. If the schedule contains private information or your organization has rules for employee records, follow those policies before sharing, printing, or keeping old versions.

Frequently Asked Questions

Does Excel have a free employee schedule template?
Excel’s template gallery may offer schedule templates, but availability varies. You can also build a reusable schedule in a blank workbook. Excel for the web is available at no charge with a Microsoft account; desktop app access depends on your license.

How do I make a weekly employee schedule in Excel?
List employees and dates, enter each shift’s start and end times, and add break information if you need paid-hour totals. Use one row per shift for flexible schedules, or a day-by-day grid for a simple team overview.

Can Excel calculate overnight shift hours?
Yes. A formula using MOD can calculate elapsed time when an end time is after midnight. Enter real Excel times and subtract any unpaid break minutes separately, then check the result against the shift details.

How do I total each employee’s weekly hours?
Record each shift’s date, employee, and calculated paid hours in separate columns. SUMIFS can add hours for a selected employee within a seven-day date range. Check that names match and that the date cells contain actual dates.

Is an Excel schedule enough for payroll?
Not necessarily. A schedule records planned shifts, which can differ from hours actually worked, and rules for pay and breaks vary. Use an appropriate timekeeping and payroll process and verify requirements for your workplace.

Related

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.