Daily Employee Schedule Template Excel: Setup & Tips

How-to basics · Updated November 22, 2026

To make a daily employee schedule in Excel, create columns for employee, date, start time, end time, break, total shift, role, and notes. With start time in C2, end time in D2, and break duration in E2, enter =IF(OR(C2="",D2=""),"",MOD(D2-C2,1)-E2) in F2 and format the result as [h]:mm. For example, 9:00 AM to 5:30 PM with a 30-minute break returns 8:00. This gives you a reusable starting template for assigning shifts and checking scheduled hours.

What a daily employee schedule should include

A useful schedule makes it easy to answer three questions: who is working, when they are working, and what they are responsible for. The right columns depend on the workplace, but a straightforward sheet usually includes:

  • Employee: Use the person’s name consistently, ideally one employee per row for each scheduled shift.
  • Date: Include the full date, even if the workbook is meant for a single day. This helps when you copy the sheet for another date or combine shifts later.
  • Start and end: Enter actual Excel times, such as 9:00 AM and 5:30 PM, rather than descriptions such as “morning.”
  • Break: Record the planned break duration in a consistent format. The formula above expects a time duration such as 0:30 for 30 minutes.
  • Total shift: Calculate the scheduled duration so managers can review staffing and employees can see the planned shift length.
  • Role or station: Identify assignments such as cashier, front desk, or opening lead when employees have different responsibilities.
  • Notes: Add operational details, such as “training,” “closing,” or “cover register.” Avoid putting sensitive personal information in a shared roster.

A compact example could have one row per employee: Alex Rivera, Tuesday, 9:00 AM, 5:30 PM, 0:30 break, 8:00 total, Front desk. If someone works two separate shifts in one day, use two rows rather than squeezing both shifts into one cell. That keeps calculations and sorting more reliable.

How to build the template in Excel

In Excel for Microsoft 365 on Windows, open a blank workbook and type the column headings into row 1. Keep each type of information in its own column. Enter a few sample rows, then select the data and choose Home > Format as Table or use Insert > Table. Confirm that the table has headers. A table makes it easier to filter by date, employee, or role, and provides a consistent format as you add rows.

  1. Set the Date column to a date format and the Start, End, and Break columns to time formats.
  2. Enter the total-shift formula in the first data row of the Total shift column, then fill it down. If the data is an Excel table, the formula will typically copy into the other rows in that column.
  3. Format the total-shift results as [h]:mm, which displays elapsed time and can show totals over 24 hours.
  4. Freeze the header row with View > Freeze Panes > Freeze Top Row if the schedule is long enough that headings would otherwise disappear while scrolling.
  5. Save a clean copy as a template file, such as an Excel Template (.xltx), if you want to start a new schedule without overwriting the original.

On Mac, the workbook structure and most formatting options are the same, although ribbon placement and shortcuts can differ slightly by Excel version. Excel for the web also supports common table, formula, and formatting tasks, but some commands may appear in a different location or have fewer options than the desktop app. The formula shown here uses standard Excel functions available in Microsoft 365.

Calculate shift lengths correctly

The formula in the opening paragraph treats the start and end entries as Excel time values, and the break as an Excel duration. MOD(D2-C2,1) allows a shift that crosses midnight to calculate as a positive duration instead of a negative one. For example, a shift from 10:00 PM to 6:30 AM with a 30-minute break produces 8:00. If start and end are both entered as 9:00 AM, the formula returns zero; it does not assume that the employee worked a full 24 hours.

Excel stores times as fractions of a day. That is why a duration such as eight hours may display incorrectly as a time of day or wrap after 24 hours if the cell has a standard clock format. Select the duration cells, open Format Cells, choose Custom, and enter [h]:mm as the type. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 is the equivalent shortcut in Excel. If you prefer decimal hours, multiply the time result by 24 and format the cell as a number, but choose one representation and use it consistently across the workbook.

Breaks must be entered in the same units expected by the formula. If E2 contains 0.5 as a plain number to mean half an hour, subtracting it directly from an Excel time value will not mean 30 minutes. Either enter the break as 0:30, or deliberately adapt the calculation to convert decimal break hours. For a simple roster, entering breaks as durations is usually easier to audit.

Optional employee-hour totals

A daily schedule may be part of a longer planning sheet that contains several dates. You can total scheduled durations by employee, provided the shift-duration cells are actual calculated durations rather than text. With employee names in A2:A100, shift durations in F2:F100, and the employee to summarize typed in H2, enter =SUMIF(A2:A100,H2,F2:F100) in I2. If the listed shifts for that employee total 8:00, 7:30, 8:00, 8:00, and 7:00, the result is 38:30. Format I2 as [h]:mm so the total displays correctly.

This is a total of scheduled duration, not necessarily a payroll calculation. The sheet may not account for actual clock-in times, unpaid or paid break rules, overtime policies, leave, or local requirements. Treat it as a planning aid and verify the organization’s rules before using schedule totals for pay or compliance decisions.

Make the sheet easier to read and maintain

Good formatting helps people catch mistakes without turning the workbook into a complicated dashboard. Use a clear header row, readable font size, consistent time formats, and a limited number of colors. For instance, one subtle fill color can distinguish headings, while a separate color can identify a training assignment. Avoid relying on color alone to communicate an important instruction; include text in the Role or Notes column as well.

Filters are useful when a manager wants to view only one date, employee, or role. If the schedule contains multiple dates, sort dates in chronological order and keep employee names spelled consistently. A dropdown list can reduce typing differences in fields such as Role: put the allowed roles in a spare range, select the cells where roles will be entered, and use Data > Data Validation to set the validation type to List and point the source to that range. The exact dialog appearance can vary between desktop and web versions.

Conditional formatting can draw attention to a specific condition, such as blank cells in a required column, but set it up carefully and test it on a few sample rows. In Excel for Microsoft 365 on Windows, common rules are available through Home > Conditional Formatting. Do not use a highlight color as a substitute for checking the underlying entries: a formula can calculate a plausible-looking result from an incorrectly entered time.

Daily view, weekly roster, or shift board?

A daily schedule template is a good fit when the main task is assigning people to one date or reviewing coverage hour by hour. A weekly roster is more useful when employees need to compare several days, spot days off, or see a repeating pattern. A shift-board layout may place time periods across columns and roles down rows, which can make coverage gaps visually obvious but is less convenient for calculating each employee’s total hours.

For a small team, one row per person per shift is generally a practical structure: it sorts cleanly, filters well, and supports simple calculations. For a larger operation with frequent changes, many employees, shift swaps, or multiple locations, a spreadsheet may become difficult to keep synchronized. A dedicated scheduling system may offer shared updates, notifications, approval workflows, or access controls, depending on the product. Excel is not automatically the better or worse choice; consider how many people edit the roster, how often it changes, and whether a single shared file is sufficient.

Common scheduling spreadsheet problems

  • Times entered as text: Typing labels such as “9am-ish” or pasting values with inconsistent formats can prevent calculations. Use recognizable time entries and check that they behave as times when formatted.
  • Break units mixed together: Do not enter 30 in one row and 0:30 in another if the formula expects a duration. Set a clear convention in the heading or an instruction cell.
  • Overnight shifts misunderstood: The MOD-based formula handles a shift that ends after midnight, but a same-time start and end is treated as zero duration. If a 24-hour shift is possible, record it explicitly using a separate duration or a different rule.
  • Overlapping assignments: A duration formula does not detect that an employee has been assigned to two places at once. Filter by employee and date, then review the start and end times, or use a separate coverage review process.
  • Totals mistaken for actual hours: Scheduled times are plans. They do not prove when someone actually worked or whether a break was taken.
  • Overwriting the template: Keep an untouched master copy and create a dated working copy for each schedule period. This makes it easier to restore the layout if someone changes headings or formulas.

Sharing, printing, and protecting the schedule

Before sharing a workbook, decide who needs to edit it and who only needs to view it. A shared file stored in OneDrive or SharePoint can support collaboration, subject to the organization’s Microsoft 365 setup and permissions. Limit access to appropriate people, especially if the workbook includes employee names or other workplace details. A schedule normally does not need personal information such as medical details or private contact information.

For a printed daily roster, set the print area to the schedule, check orientation and scaling in the print settings, and preview the page before printing. A wide table may fit better in landscape orientation, but shrinking it too much can make names and times hard to read. If the roster spans multiple pages, repeat the header row where the print settings allow it. For digital distribution, keep a visible “last updated” date or version note so readers can tell whether they have the current schedule.

Frequently Asked Questions

Is there a built-in daily employee schedule template in Excel?
Excel may offer templates through its New workbook screen, and available templates can vary over time and by account. You can also create a simple custom schedule with employee, date, start, end, break, total, role, and notes columns, then save a clean copy as a reusable template.

How do I calculate hours for an overnight shift in Excel?
Use a calculation that accounts for midnight, such as the MOD formula above, and enter valid start and end times. With a 10:00 PM start, 6:30 AM end, and 0:30 break duration, it returns 8:00. The result cell should use the [h]:mm format.

Should I put each employee in a row or each shift in a row?
For a schedule that needs filtering and hour calculations, use one row per employee per shift. If one person has two separate shifts in a day, give each shift its own row. A grid with employees down the side and times across the top can be easier to scan visually, but may be harder to summarize.

Can Excel tell me if two employees are scheduled at the same time?
A basic shift-duration formula does not check staffing coverage or identify overlaps. You can review the schedule by date, role, and time, or build more advanced checks, but a simple template should not be treated as an automatic coverage validator.

Can this template calculate payroll?
It can total planned shift durations, but that is not the same as a verified payroll calculation. Actual hours, break treatment, overtime rules, and other requirements may affect pay. Use the schedule for planning and confirm payroll calculations with the organization’s approved process.

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.