Employee Work Schedule Template Excel: Free Setup Guide

How-to basics · Updated November 19, 2026

Yes—free employee work schedule templates are available to use in Excel, and you can also create a simple one yourself without buying a scheduling app. In Excel for Microsoft 365 on Windows, start at File > New and search the template gallery for schedule or staff schedule; if a suitable template is not listed, a table with employee names, dates, shift times, and hours is a practical starting point.

Where to find a free Excel schedule

Excel’s template gallery and Microsoft Create are places to look for ready-made workbooks. Search with terms such as employee schedule, staff schedule, or weekly work schedule. Template names and availability can change, so check that the file opens in Excel and that its layout suits your team before entering real information. A free template may be a downloadable workbook or an online template you can open and save as your own copy.

Some templates are designed for a single week; others show a monthly calendar, multiple employees, or shift assignments by department. A visually polished calendar is not necessarily the best choice for payroll preparation. Before adopting one, look for clear date and time fields, enough rows for your staff, and a way to total scheduled hours. Review any formulas in a downloaded workbook rather than assuming every calculation fits your policies.

To keep an original intact, use File > Save As and give your working copy a recognizable name, such as “Front Desk Schedule – Week of Nov 9.” In Excel for the web, use File > Save As or make a copy through the available file options in OneDrive. Menu wording can vary slightly with updates and account settings. You can also build the layout below in a blank workbook.

Choose a layout that matches the way you schedule

For a small team with predictable shifts, a weekly grid is easy to scan: employees run down the left side and days of the week across the top. Put a shift such as “9:00 AM–5:00 PM” in each assigned day. This format communicates coverage quickly, but it is less convenient for calculating hours unless start and end times are stored separately or the workbook includes a well-designed calculation area.

A shift-by-shift table is usually more adaptable when staff work different hours, shifts cross midnight, or schedules change frequently. Use one row per employee and shift, with columns for employee, date, start time, end time, unpaid break, and scheduled hours. The same person appears on several rows if they work several shifts. This structure is also easier to sort or filter by date or employee.

Consider these factors before choosing:

  • Team size: A compact grid may suit a small group; a row-based table can expand more naturally as shifts are added.
  • Shift patterns: Rotating or overnight shifts need explicit dates and start and end times.
  • Coverage needs: If you need to see how many people are assigned to a particular role or time, include a role or department column.
  • Sharing: A schedule intended for printing may need larger text and a one-page layout; a working file needs filters and space for updates.
  • Hour totals: Decide whether you need totals by employee, by day, or both, and make sure the template can show them clearly.

Build a basic weekly schedule in Excel

In a blank workbook, enter these headings in row 1: Employee, Date, Start, End, Unpaid break (hours), and Scheduled hours. Enter each shift on its own row, starting in row 2. Store dates as Excel dates and start and end times as time values, not as text. For example, type 9:00 AM into a time cell. In the break column, enter a decimal number of hours: 0.5 means a 30-minute unpaid break, and 1 means one hour.

  1. Enter employee names consistently. Avoid variations such as “Sam Lee” on one row and “Sam” on another if you plan to total by name.
  2. Enter one date and one shift per row. For a person working Monday and Wednesday, create two rows.
  3. Format the Date column as a date and the Start and End columns as times. Select the cells, then use the number-format controls on the Home tab.
  4. Turn the range into an Excel table by selecting it and choosing Insert > Table. Confirm that the table has headers. Tables make it easier to filter and add rows; Excel generally extends calculated-column formulas as new rows are added.
  5. Save the workbook in a shared location if other authorized schedulers need to edit it, and agree on who is responsible for publishing the current version.

A table is helpful but not compulsory. If you prefer a simple range, leave blank rows out of the middle of the data and use clear headings so that sorting and filtering work as expected. In Excel for Mac, the same core approach and Insert > Table feature are available, although ribbon placement and some labels can differ by version. Excel for the web supports common table and formatting tasks, but the interface may look different from the Windows desktop app.

Calculate scheduled hours correctly

With Employee in A, Date in B, Start in C, End in D, unpaid break hours in E, and Scheduled hours in F, put this formula in F2 and fill it down:

=MAX(0,MOD(D2-C2,1)*24-E2)

The formula treats a time difference that passes midnight as an overnight shift, converts Excel’s time fraction to hours, and subtracts the break entered as decimal hours. For a shift from 10:00 PM to 6:00 AM with a 0.5-hour unpaid break, the result is 7.5 scheduled hours: eight hours elapsed minus half an hour. The MAX function prevents a negative displayed total if a break entry is accidentally larger than the calculated shift, but it does not correct the underlying mistake, so check unusual results.

This calculation assumes the start and end cells contain valid Excel time values and that the shift is less than 24 hours. If the end time is earlier than the start time, MOD interprets the shift as crossing midnight. If your organization records paid breaks, do not subtract them as unpaid time. If break entries are stored as Excel time values instead of decimal hours, the calculation needs to subtract a time value and convert it appropriately; keep one consistent convention throughout the workbook.

To total scheduled hours by employee, make a small summary area. With employee names in A2:A100, hours in F2:F100, and the name to summarize in H2, enter this in I2:

=SUMIF($A$2:$A$100,H2,$F$2:$F$100)

If H2 contains “Sam Lee,” the formula adds the hours from rows where column A matches that name. The result is the sum of the scheduled shifts in the specified range, not a record of hours actually worked. Adjust the ranges if your schedule extends beyond row 100. For a growing table, a structured-reference formula can be more maintainable, but ordinary cell ranges are often easier for a new workbook.

Make the schedule easier to read and maintain

Use consistent time formats and plain labels. A shift should not alternate between “9-5,” “9:00 AM to 5:00 PM,” and a mixture of text and numbers. Keep notes such as “training” or “closing lead” in a separate Notes or Role column instead of replacing the time fields. That keeps calculations intact while giving staff useful context.

Freeze the heading row so column labels remain visible while you scroll: in Excel for Windows, choose View > Freeze Panes > Freeze Top Row. Apply filters using the table header to view one employee, date, or role at a time. Use a restrained fill color to distinguish departments or shift types, and make sure color is not the only way important information is communicated. If the workbook will be printed, check the print preview and page orientation before distributing it.

Protect the quality of entries by using Data > Data Validation for fields where a controlled list is useful, such as department or shift type. For employee names, a dropdown can reduce spelling inconsistencies, but update its source list when staff change. Validation helps prevent some entry errors; it does not guarantee a correct schedule or enforce employment rules. Keep a clear “last updated” date or version label so readers can tell whether they have the current copy.

Common template problems and how to avoid them

  • Hours show as a fraction or a clock time: Excel stores times as parts of a day. For a result expressed in hours, the formula above multiplies by 24; format the result as a number, not as a time of day.
  • Totals do not match the schedule: Check for text-formatted times, misspelled employee names, blank or incorrect break entries, and rows outside the formula’s range.
  • Overnight shifts appear negative: Use a formula that handles midnight, such as the MOD calculation, and verify that both endpoints are entered as time values.
  • Sorting scrambles the schedule: Sort the whole table, not one column by itself. Sorting only the names or dates can separate values that belong to the same shift.
  • Two versions circulate: Choose one shared source of truth and publish a dated copy or view for staff. Avoid relying on several emailed attachments as if they were all current.
  • Colors are mistaken for assignments: Put the actual shift, role, or status in a cell as well. Formatting should help readers interpret information, not replace it.

Excel templates versus scheduling software

Excel is a reasonable fit when the schedule is relatively simple, a manager can maintain it, and the team mainly needs a clear plan. It is flexible: you can tailor columns, print a weekly view, and add straightforward totals without learning a dedicated platform. For a small organization, a well-maintained workbook may be all that is required.

A spreadsheet has limits. It will not automatically know whether an employee is available, whether a shift has been accepted, or whether a change has reached every staff member. A formula can total planned hours, but it does not by itself confirm actual attendance or determine whether a schedule complies with applicable rules. Larger teams, frequent shift swaps, multiple locations, and complex coverage requirements may justify comparing purpose-built scheduling tools. Evaluate their current features, pricing, access controls, and data handling directly; these vary by provider and plan.

Whichever method you use, scheduled hours are not automatically the same as worked hours or paid hours. Clock-in records, approved edits, payroll rules, and applicable local requirements may affect those figures. Treat a schedule template as a planning document, not as a substitute for payroll records or professional guidance on employment obligations.

Privacy and sharing considerations

A schedule can reveal work patterns and contact details, so include only information staff need to do their jobs. Do not place sensitive personal notes in a workbook shared with the whole team. Review sharing permissions in OneDrive or SharePoint, and restrict editing to people who are responsible for scheduling. A view-only copy can reduce accidental changes when most readers only need to see their shifts.

Before sending a schedule, check the date range, employee names, times, breaks, and coverage. When updates are made after publication, make the change easy to identify and communicate it through the channel your team normally uses. A free template is useful only if people can recognize the latest version and understand what they are expected to do.

Frequently Asked Questions

Is there a free employee schedule template in Excel?
Yes. Search Excel’s New template gallery or Microsoft Create for employee, staff, or work schedule templates. Availability can vary, and you can also create a basic schedule in a blank workbook using employee, date, start, end, break, and hours columns.

How do I make a weekly employee schedule in Excel?
Choose either a weekly grid or a table with one row per shift. Add clear headings, enter dates and times as spreadsheet values, and use separate rows when an employee works multiple shifts. Save a working copy and check that the layout is readable before sharing or printing it.

Can Excel calculate employee shift hours?
Yes, if the start and end times are valid time values and breaks are entered consistently. A formula can calculate scheduled duration, including a shift that crosses midnight, but the result is planned time rather than proof of hours actually worked.

Can I use an Excel schedule template in Google Sheets?
Many basic .xlsx workbooks can be opened or imported in Google Sheets, but formatting and formulas may not transfer exactly. Check the converted file, especially time calculations, print layout, and any Excel-specific features, before using it as the official schedule.

Is a free Excel schedule suitable for payroll?
It can help plan shifts and estimate scheduled hours, but a schedule is not automatically a payroll or timekeeping record. Confirm actual hours and applicable pay rules using the records and processes your organization requires.

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.