An Excel work schedule template is a reusable spreadsheet for assigning employees to dates and shifts, tracking hours, and preparing a readable weekly roster. In Microsoft Excel for Microsoft 365 on Windows, start with File > New and search for “schedule,” or build a simple table with employee, date, start time, end time, break, and hours columns.
What an Excel work schedule template can do
A schedule template gives you a consistent place to record who works, when a shift begins and ends, and any relevant notes. It can be as simple as a weekly grid or as detailed as a shift-by-shift log with calculated hours. The right design depends on whether the schedule is mainly for communication, time tracking, or both.
A weekly grid is easy to scan: employees appear down the left side, days appear across the top, and each cell contains a shift such as “9:00 AM–5:00 PM.” That layout works well for a small team with predictable shifts. A shift log uses one row per shift and separate columns for date, start, end, break, and total hours. It is easier to filter and calculate, especially when staff work different hours or overnight shifts.
A schedule is not automatically a time clock or a payroll system. Planned hours may differ from hours actually worked, and a spreadsheet does not independently verify attendance or calculate every workplace requirement. If hours will be used for payroll or compliance, confirm the records and rules through the appropriate process rather than treating a template as authoritative.
Find a ready-made template or start from a blank workbook
In Excel for Microsoft 365 on Windows, select File > New and search the available templates for “schedule” or “work schedule.” The results can vary with account settings, language, and the templates available at the time. Preview a candidate before using it: some results may be project planners, calendars, or staff rosters rather than a shift schedule.
A ready-made workbook can save setup time, but inspect its formulas and fields before entering real information. Check whether its week begins on the day your team uses, whether it supports part-time and overnight shifts, and whether it distinguishes planned from actual hours. Remove unused fields and test a few entries so that totals and date labels behave as expected.
To build your own, choose Blank workbook, create clear column headings, and save a clean copy as your master. Keep one version as the reusable template, then make a separate copy for each scheduling period. This reduces the risk of accidentally overwriting a prior week or carrying old assignments into a new one.
Choose a layout that fits the work
For a basic weekly roster, put employee names in the first column and the seven dates in the next columns. Enter each shift in its day cell, and use a separate notes column for information such as a location or role. Avoid squeezing several employees or shifts into one cell: it may look compact, but it becomes difficult to filter, total, or reuse the data.
For a schedule that needs reliable hour calculations, use one row per shift. A practical set of headings is:
- Employee
- Date
- Start time
- End time
- Unpaid break in hours
- Hours worked or scheduled
- Role, location, or notes, if needed
This format repeats an employee’s name when that person has multiple shifts, but the structure makes sorting and totaling simpler. If managers need a calendar-style view for posting, keep the shift log as the source of calculations and create a separate, readable weekly view. Make sure the two views are updated together; a manually copied display can become out of date.
Set up shift-hour calculations
Excel stores recognized times as fractions of a day. If start times are in column C, end times in D, unpaid break lengths in decimal hours in E, and the calculated shift hours in F, enter the following in F2 and fill it down:
=MOD(D2-C2,1)*24-E2
For example, a shift from 9:00 AM to 5:30 PM with a 0.5-hour unpaid break returns 8 hours: the elapsed time is 8.5 hours, less the half-hour break. MOD also handles an overnight shift when the end time is after midnight. For example, 10:00 PM to 6:00 AM with a 0.5-hour break returns 7.5 hours. Enter breaks as decimal hours, so 30 minutes is 0.5 and 15 minutes is 0.25. Format the hours column as a number, not as a clock time.
This calculation assumes that each date in column B is the date the shift starts, that Excel recognizes the entries in C and D as times, and that E contains a numeric break value. A shift whose start and end times are identical returns zero hours with this formula; enter overnight shifts with distinct times. Also, the formula calculates elapsed time minus the entered break—it does not decide whether a break is required or whether a particular deduction is appropriate.
To total an employee’s hours for a seven-day period, assume employee names are in A2:A100, shift dates are in B2:B100, and calculated shift hours are in F2:F100. Put the employee to summarize in H2 and the first date of the week in I2, then use:
=SUMIFS($F$2:$F$100,$A$2:$A$100,H2,$B$2:$B$100,">="&I2,$B$2:$B$100,"<"&I2+7)
If Alex has three shifts in that date range with calculated hours of 8, 7.5, and 6, the result is 21.5 hours. The date test includes the week-start date and excludes the date seven days later. Enter I2 as a real Excel date, not text that only looks like a date. Check that names are spelled consistently and that the hours cells contain numbers; otherwise a total may omit a shift or appear lower than expected.
Make the schedule easier to enter and read
Convert a shift log to an Excel table by selecting its range and choosing Home > Format as Table. Tables provide consistent heading styles, filter controls, and automatic expansion when new rows are added. Confirm that “My table has headers” is selected if Excel prompts you. A table can make a growing schedule easier to manage, though it does not replace checking that formulas extend correctly.
Use consistent date and time formats so the schedule is readable across the team. For example, display dates as “Mon, 4 May” and times in a single format such as “9:00 AM.” Keep the underlying entries as Excel dates and times; typing a date or time with an apostrophe at the start stores it as text and can interfere with sorting or calculations.
For a weekly grid, use restrained color to distinguish teams, roles, or shift types, and include a small legend if color carries meaning. Do not rely on color alone to communicate an assignment: retain the employee name, time, or role as text. On a large sheet, freeze the heading area with View > Freeze Panes so labels remain visible while scrolling. Before printing, use Page Layout options to check orientation, margins, scaling, and page breaks; a schedule that fits on screen may otherwise print across several pages.
Reduce entry mistakes and protect the workbook
Use Data > Data Validation to restrict entries where a controlled list is useful, such as role names or locations. A drop-down list can reduce variations such as “Front desk” and “Front Desk,” which may make sorting or summaries less dependable. Validation helps prevent some accidental entries, but pasted data can still create inconsistencies, so review the completed roster.
Conditional formatting can draw attention to useful conditions, such as a blank assignment or an unusually long calculated shift. Choose Home > Conditional Formatting and select a rule that fits the data. Test rules with a few known examples: a color cue that is unclear or applied to the wrong range can be more confusing than no cue.
Keep the workbook understandable for the next person who edits it. Use descriptive sheet names, label units clearly, and avoid hiding assumptions in unexplained formulas. If multiple people will edit the same schedule, store it in a location that supports their access needs and agree on who is responsible for resolving conflicting changes. A version history or dated copies can help recover from accidental edits, but availability depends on where the workbook is stored and the account or organization settings.
Schedules can contain personal information about people’s shifts and availability. Share only with people who need access, avoid placing sensitive personal details in general notes, and follow your organization’s retention and access rules. A password or a hidden worksheet should not be treated as a substitute for controlling who receives the file.
Excel templates compared with scheduling software
Excel is often a sensible choice for a small team with a straightforward roster, a manager who can maintain the file, and no need for automated shift notifications. It is flexible, familiar to many users, and can be customized without purchasing a dedicated scheduling product. The trade-off is that someone must maintain the workbook, check formulas, distribute updates, and make sure everyone is viewing the current version.
Dedicated scheduling software may be a better fit when a workplace needs features such as employee availability collection, shift swaps, notifications, multiple locations, or integration with timekeeping. Exact features and prices vary by provider and plan, so compare current product details rather than assuming every system includes the same capabilities. Google Sheets is another spreadsheet option for browser-based collaboration, but it uses a different interface and some Excel-specific features or formatting may not transfer exactly.
A useful way to decide is to list the tasks the schedule must support: assigning shifts, sharing changes, tracking actual attendance, totaling hours, and retaining past records. If the spreadsheet handles only the first two, do not assume it handles the rest. When the schedule becomes difficult to audit or maintain, the cost of staff time and errors may matter more than the price of a dedicated tool.
Common problems to check before sharing
- Totals are wrong: Check whether dates and times are stored as values, breaks use decimal hours, and the formula covers every shift row.
- An overnight shift looks negative: A basic end-minus-start calculation does not account for midnight. The MOD formula above does, provided the shift has distinct start and end times.
- A shift is missing from a weekly total: Confirm the employee name matches, the date is within the intended seven-day period, and the date is not stored as text.
- The printed page is hard to read: Check scaling and page breaks rather than shrinking the sheet until the text is too small. Consider printing a separate view for each team or week.
- Two versions disagree: Choose one official workbook location and tell users how updates will be announced. Avoid sending multiple attachments without identifying which one is current.
Before distributing a new schedule, review it as a reader would: check the week dates, employee names, shift times, locations, and any notes. Test hour totals against a few hand-calculated shifts. If the workbook contains both a detailed log and a display grid, compare them for consistency rather than assuming that one automatically updates the other.
Frequently Asked Questions
Does Excel have a free work schedule template?
Excel’s File > New template search may show schedule-related templates, but the available results can vary. You can also create a basic weekly roster in a blank workbook using employee, date, and shift columns.
How do I calculate hours in an Excel work schedule?
For start time in C2, end time in D2, and an unpaid break in decimal hours in E2, use =MOD(D2-C2,1)*24-E2. The result is elapsed shift hours minus the entered break.
Can Excel calculate overnight shifts?
Yes. The MOD formula handles an end time after midnight when the shift start and end times are different. Make sure the date column represents the date the shift begins if you are summarizing hours by workweek.
Should I use a weekly grid or one row per shift?
Use a grid when the main goal is a quick visual overview and shifts are simple. Use one row per shift when you need to filter, calculate hours, or manage many different shift times. A detailed log plus a separate display view can serve both needs.
Can I share an Excel schedule with my team?
Yes, but use a shared location and access settings appropriate for your team, and establish one official version. The exact collaboration options depend on where the workbook is saved and the accounts or organization settings in use.
Related
- Excel Shortcut to Insert a Cut Row
- Excel Shortcut to Insert Another Row in Windows and Mac
- Excel Shortcut to Select to the End of a Column
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Duplicates in Excel: Keyboard ShortcutIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt, then A,…
- PowerPoint Change Slide Size: Steps, Options, and TipsTo change slide size in PowerPoint for Microsoft 365 on Windows, open the presentation and select Design >…
- Append Data in Excel with Power Query: A Step-by-Step GuideTo append data in Excel with Power Query, load each source table as a query, open the Power…
- Excel Group Rows: Keep the Top Row Visible When CollapsedYes—Excel can keep a top row visible when you group rows, but the row must be outside the…
- Excel Group Rows With Matching Values in a ColumnTo group rows that share a value in Excel, first sort the list by that column, then use…
- Excel Yellow Highlight Shortcut: Apply Cell FillIn Excel for Microsoft 365 on Windows, select the cell or range, then press Alt, H, H to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.