Excel Employee Hourly Schedule Template: How to Build One

How-to basics · Updated November 22, 2026

The quickest way to get an employee hourly schedule template in Excel is to use a built-in template: open Excel, go to File > New, type “employee schedule” in the search box, and choose one of the free options like “Employee schedule with breaks” or “Weekly schedule with lunch breaks.” These templates come with pre‑formatted time grids, shift columns, and formulas for total hours, so you can start entering names and shifts immediately. If you need more control, you can also build a custom template from scratch using basic Excel formulas—this article explains both approaches, how to choose the right one, and how to avoid common mistakes.

Why Use an Excel Template Instead of Paper or Paid Software

Excel templates are popular because they are free (if you already have Microsoft 365), flexible, and work offline. Unlike paper schedules, you can copy a week’s schedule, adjust times, and automatically calculate hours worked. Unlike paid scheduling software like Deputy or When I Work, Excel has no subscription cost and no learning curve for most managers. The trade‑off is that Excel lacks automated shift reminders, time‑clock integration, and mobile apps—so if you have more than 20 employees or need real‑time updates, a dedicated tool might be better.

How to Find and Use Excel’s Built‑In Schedule Templates

Excel for Microsoft 365 (Windows and Mac) includes several schedule templates. To access them:

  1. Open Excel and click File > New.
  2. In the search box, type “employee schedule” or “shift schedule”.
  3. Browse the results—look for templates that include “breaks” or “weekly” in the name.
  4. Click a template and then click Create to download it.

On a Mac, the steps are the same (File > New from Template…). The template opens as a new workbook. Most templates have a sheet for each week, with days across the top and employee names down the left. You simply type the shift start and end times in the cells, and the template calculates total hours per day and per week. Some templates also include columns for lunch breaks—enter the break duration, and the formula subtracts it from the total.

If you cannot find a template you like, you can download free ones from Microsoft’s official template gallery at templates.office.com (search “employee schedule”).

Building a Custom Hourly Schedule from Scratch

If you prefer a schedule tailored to your business, create your own. Here’s a simple layout that works for most small teams:

  • Columns: A = Employee Name, B = Monday, C = Tuesday, D = Wednesday, E = Thursday, F = Friday, G = Saturday, H = Sunday, I = Weekly Total.
  • Rows: Row 1 = headers, Row 2 onward = each employee.
  • Enter shifts: Type start and end times in the format 9:00 AM and 5:00 PM (Excel recognizes these as times). To show a shift that spans midnight, use 9:00 PM and 5:00 AM—but then the formula must account for crossing midnight (see below).

To calculate daily hours, use the formula =IF(B2="",0,(B2_end - B2_start)*24)—but that requires separate start and end cells. A simpler approach is to put start and end in the same cell? That doesn’t work well. Instead, use two rows per day or two columns per day (e.g., Monday Start and Monday End). For clarity, many managers use a separate sheet for each week with a grid where each cell contains a shift code like “9-5” (but then Excel cannot calculate hours automatically).

For a fully automatic schedule, use this layout:

  • Columns: A = Employee, B = Mon Start, C = Mon End, D = Tue Start, E = Tue End, … up to Sun End.
  • For each day, calculate hours in a helper column (e.g., column after Sun End).
  • Use the formula =IF(OR(B2="",C2=""),0,IF(C2>B2,(C2-B2)*24,(C2+1-B2)*24)) – this handles shifts that cross midnight.

Example: With B2 = 9:00 AM and C2 = 5:00 PM, the formula returns 8 (hours). If B2 = 11:00 PM and C2 = 7:00 AM, it returns 8 as well. The +1 adds a full day when the end time is earlier than the start time.

To sum weekly hours for each employee, use =SUM(H2:N2) (assuming H:N are the daily hour cells). For a grand total of all employees, use =SUM(H2:H20).

Key Formulas for Hourly Schedules

Besides the shift‑length formula, you often need to calculate overtime, break deductions, or total labor cost. Here are common formulas with a clear example:

  • Break deduction: If you have shift start in B2, end in C2, and break duration in D2 (as a time value like 0:30 for 30 minutes), use =IF(C2>B2,(C2-B2-D2)*24,(C2+1-B2-D2)*24). The result is hours worked after break.
  • Overtime: Suppose regular hours are in E2 (calculated as above) and you want to flag anything over 8 hours. Use =IF(E2>8,E2-8,0) to get overtime hours.
  • Labor cost: If hourly rate is in F2 and total hours in E2, use =E2*F2 to get gross pay for that employee (before taxes). For weekly total, sum the column.

All formulas assume your times are entered as Excel time values (e.g., type 9:00 and Excel shows 9:00 AM). If you type “9-5” as text, formulas will not work.

How to Choose the Right Template for Your Business

Consider the following factors when selecting or building a template:

  • Number of employees: If you have fewer than 15, a simple spreadsheet works. For 20+, look for a template with separate sheets per week or consider scheduling software.
  • Shift complexity: If you have rotating shifts, split shifts, or overnight shifts, you need a template that accommodates start/end times and break entries. The built‑in “Employee schedule with breaks” template is a good start.
  • Need for automatic calculations: If you want to avoid manual math, choose a template that includes formulas for total hours. Many free templates already have these.
  • Printing and sharing: If you need to print a weekly schedule, look for a template with a clean layout that fits on one page. You can adjust print settings via File > Print and set scaling to fit.
  • Mac vs. Windows: Templates work the same on both, but some third‑party templates may use features that are only in newer Excel versions. Stick to Microsoft’s official templates to avoid compatibility issues.

Common Problems and How to Fix Them

Even with a good template, you’ll run into a few issues:

  • Times not calculating: This usually happens because the cell is formatted as text. Select the cells, go to Home > Number Format and choose “Time.” Then re‑enter the times.
  • Negative hours for overnight shifts: Use the IF(C2>B2,...) formula shown above to avoid negative values.
  • Breaks not deducted: Make sure the break cell is formatted as time (e.g., 0:30) and that the formula references it correctly.
  • Printing cuts off columns: Go to Page Layout > Print Area > Set Print Area, and adjust column widths or use Scale to Fit under Page Setup.
  • Accidentally editing formulas: Protect the formula cells by selecting them, then go to Review > Protect Sheet. This prevents accidental changes.

Excel vs. Google Sheets for Hourly Schedules

If you need to collaborate in real time, Google Sheets is a free alternative. The formulas are almost identical—for example, the shift‑length formula works the same. The main differences are:

  • Google Sheets saves automatically to the cloud, so multiple people can edit simultaneously.
  • Excel for Microsoft 365 has more advanced features like Power Query and better charting, but for a simple schedule, both work.
  • To use the same template in Google Sheets, you can upload the Excel file to Google Drive and open it with Google Sheets—it will convert most formulas.

If you start in Excel and later move to Google Sheets, be aware that some Excel‑only functions (like XLOOKUP) may not work in Google Sheets, but for basic schedules you won’t need them.

Frequently Asked Questions

Can I make a schedule that automatically highlights conflicts (double‑booked employees)?

Yes, you can use conditional formatting. For example, select the range of shift cells, go to Home > Conditional Formatting > New Rule > Use a formula, and enter a formula that checks if the same employee appears twice in the same day column. A simple approach is to use =COUNTIF(B$2:B$20,B2)>1 (assuming B2:B20 is the column for Monday). This will highlight duplicate names in that column. Note that this works only if you enter employee names in each shift cell, not just times.

How do I calculate hours when an employee works a split shift (e.g., 9-12 and 1-5)?

Enter the two shifts in separate cells. For example, put 9:00 AM in B2, 12:00 PM in C2, 1:00 PM in D2, and 5:00 PM in E2. Then use =((C2-B2)+(E2-D2))*24 to get total hours. If the shift crosses midnight, adjust each part with the IF formula.

Is there a way to automatically email the schedule to employees from Excel?

Excel does not have a built‑in email scheduler. You can use a macro (VBA) to send emails via Outlook, but that requires programming knowledge and Outlook installed. A simpler alternative is to save the schedule as a PDF (File > Save As > PDF) and attach it to an email manually, or use a cloud service like OneDrive and share a link.

Can I use Excel on my phone to edit the schedule?

Yes, the Excel mobile app (free for iOS and Android) lets you view and edit workbooks. However, complex formulas and conditional formatting may not work perfectly on mobile. For quick edits, it’s fine, but for heavy editing, use a computer.

What if I need to schedule employees across multiple locations?

You can add a “Location” column to your template and filter by location using Data > Filter. Or create separate sheets for each location and link them with formulas if needed. For more than three locations, consider scheduling software.

Are there any free templates that include lunch breaks and overtime?

Yes, the built‑in “Employee schedule with breaks” template includes break columns and calculates net hours. For overtime, you may need to add a column with the formula =IF(TotalHours>8,TotalHours-8,0). Many free templates on templates.office.com also include overtime columns—search for “employee schedule with overtime.”

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.