The fastest way to get an hourly schedule in Excel is to use a built-in template: open Excel, go to File > New, type “hourly schedule” in the search box, and choose one of the free templates (like “Hourly Schedule” or “Weekly schedule with hourly slots”). If you prefer to build your own from scratch, you can create a simple grid with time intervals in column A and days of the week across columns B–H, then format it with borders and fill colors. This article explains both approaches in detail, including how to customize, automate, and troubleshoot your schedule.
Why Use an Excel Hourly Schedule?
An hourly schedule template helps you plan a day, week, or month down to specific time slots. Unlike a paper planner, Excel lets you edit, copy, and recolor cells instantly, and you can add formulas to calculate total hours worked or track tasks. It’s useful for shift workers, students, freelancers, and anyone who needs to see a granular view of their time. You can also share it with colleagues via OneDrive or email, and it works on Windows, Mac, and Excel for the web.
Built-in Templates vs. Building Your Own
Excel ships with several free hourly schedule templates. To find them:
- Open Excel and click File > New.
- In the search box, type “hourly schedule” and press Enter.
- Browse results like “Hourly schedule” (a weekly grid with 1-hour rows) or “Daily schedule” (a single day with half-hour slots).
- Click a template and then click Create to download it.
These templates are pre-formatted with time labels, day columns, and often a notes area. They are a great starting point because they save you setup time. However, they may not match your exact needs—for example, you might want 30-minute intervals or a different start time. In that case, building your own is straightforward.
To build from scratch, follow these steps:
- In a new worksheet, type the days of the week in cells B1:H1 (or A1:G1 if you want the first column for time).
- In column A, starting at A2, enter your start time (e.g., 8:00 AM). In A3, enter the next interval (e.g., 9:00 AM). Select both cells and drag the fill handle down to populate the rest of the day.
- Select the entire range (e.g., A1:H16 for a 8 AM–5 PM day with hourly slots). Go to Home > Borders and choose “All Borders” to add gridlines.
- Add a title in A1 (or merge cells above) and format headers with bold text and a fill color.
- Adjust row heights to make each hour visually distinct.
For 30-minute intervals, enter 8:00 AM in A2 and 8:30 AM in A3, then drag down. Excel recognizes time values, so you can format them as “h:mm AM/PM” using Home > Number Format > Time.
How to Customize Your Schedule
Once you have a basic grid, you can tailor it to your workflow:
- Change time intervals: Instead of typing each time, use a formula. With start time in A2, enter
=A2+TIME(0,30,0)in A3 and drag down. This adds 30 minutes to the previous cell. - Add color coding: Select a range (e.g., B2:H16) and go to Home > Conditional Formatting > New Rule. Choose “Use a formula to determine which cells to format.” For example, to highlight cells containing the word “Lunch,” enter
=$B2="Lunch"(adjust the column reference to your first data column). Set a fill color and click OK. - Insert a total hours formula: If you track start and end times in separate columns (say, start in A, end in B), you can compute hours with
=B2-A2and format the result as a number (e.g., 8.5 for 8 hours 30 minutes). For a weekly total, sum the column with=SUM(C2:C16). - Add a dropdown for tasks: Select the cells where you’ll enter activities, go to Data > Data Validation, choose “List,” and enter items separated by commas (e.g., “Meeting,Workout,Study”). This speeds up entry and keeps text consistent.
For a more advanced schedule, you can use Excel’s Table feature (Ctrl+T) to make sorting and filtering easier. Tables automatically expand when you add rows, and formulas in table columns update automatically.
Common Problems and How to Fix Them
Even simple schedules can hit snags. Here are the most frequent issues and solutions:
- Time doesn’t display correctly: If you type “8:00” and Excel shows a decimal like 0.3333, that’s because Excel stores times as fractions of a day. Select the cells, press Ctrl+1 (or Cmd+1 on Mac) to open Format Cells, choose “Time” under the Number tab, and pick a format like “1:30 PM.”
- Row heights are too small: After adding borders, rows may appear cramped. Select all rows, right-click, choose “Row Height,” and set a value like 20–30 pixels.
- Printing cuts off columns: Go to Page Layout > Print Area > Set Print Area to select just your schedule. Then in Page Layout > Scale to Fit, set Width to “1 page” so it prints on one sheet.
- Conditional formatting doesn’t work: Ensure the formula references the correct absolute/relative cells. For a range starting at B2, use
=B2="Lunch"(no dollar signs) so it applies to each cell relative to its position.
Comparing Excel to Other Tools
Excel is not the only option for hourly scheduling. Google Sheets offers similar functionality for free in a browser, with real-time collaboration. However, Excel’s desktop version is faster for large datasets and has more advanced formatting controls. Dedicated scheduling apps like Calendly or Toggl Plan are better for booking appointments or team project timelines, but they lack the flexibility of a blank spreadsheet. For a simple personal schedule, Excel is often the best balance of power and cost—it’s included in Microsoft 365, and you can use the free Excel for the web if you have a Microsoft account.
Cost and Accessibility
Excel is part of Microsoft 365, which costs a subscription fee (typically around $10/month for personal use). However, you can use Excel for free in a web browser at office.com by signing in with a free Microsoft account. The web version supports most formatting and formulas, though some advanced features (like macros) are not available. If you already have Excel installed, the built-in templates are free to use. There are also many free third-party template sites, but be cautious: some may contain macros or formatting that doesn’t transfer cleanly. Always download from reputable sources like Microsoft’s official template gallery.
Safety and Data Accuracy Tips
When using an hourly schedule for work or billing, accuracy matters. Here are a few safety checks:
- Double-check time formulas: If you calculate hours with
=B2-A2, ensure the format is set to “Number” (not “Time”) so you see decimal hours. For example, 9:00 AM to 5:30 PM yields 8.5 hours, which is correct. To convert to hours and minutes, use=TEXT(B2-A2,"h:mm"). - Back up your file: Save a copy to OneDrive or a USB drive. If you use macros (VBA), remember that macros cannot be undone with Ctrl+Z, so always save a backup before running one.
- Protect formulas: To prevent accidental edits, select the cells with formulas, go to Review > Protect Sheet, and uncheck “Select locked cells” after locking the formula cells (right-click > Format Cells > Protection > Locked).
Frequently Asked Questions
Can I make an hourly schedule that repeats weekly?
Yes. Create a schedule for one week, then copy the entire sheet (right-click the tab and choose “Move or Copy”) and change the dates in the header. Or use a template with date formulas that auto-update, but that’s more complex.
How do I add a lunch break to my schedule?
Just type “Lunch” in the appropriate time slot. If you want to exclude lunch from total hours, you can subtract it: for example, if you track start and end times in columns, use =C2-B2-TIME(1,0,0) to subtract one hour for lunch.
Can I use Excel on my phone to edit the schedule?
Yes. The Excel mobile app (iOS/Android) allows basic editing and formatting. For real-time collaboration, save the file to OneDrive and share the link.
Why does my schedule print with blank pages?
This usually happens because the print area includes empty columns or rows. Set the print area to your data range (select the range, then Page Layout > Print Area > Set Print Area) and adjust scaling to fit one page.
Is there a way to automatically highlight the current time?
Yes, with conditional formatting. Select the time column (e.g., A2:A16) and create a new rule using the formula =A2<=NOW() and =A2>=NOW()-TIME(1,0,0) (for a one-hour window). This highlights the row that contains the current hour. Note that NOW() recalculates only when the sheet recalculates, so you may need to press F9 to update.
Can I use Excel’s hourly template for employee scheduling?
Yes, but for multiple employees you might prefer a separate column per employee or a more advanced template. Excel’s built-in “Employee schedule” template (search “employee schedule” in the template gallery) is a good starting point, and you can add formulas to calculate total shifts.
Related
- Excel Calendar Template for Content Planning
- Excel Calendar Template for Events: How to Build One
- Excel Business Template for Invoice: How to Use
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets IF OR: How to Test Multiple ConditionsTo use IF with OR in Google Sheets, put OR inside the IF condition: =IF(OR(A2="Open",B2>=100),"Review",""). This returns “Review”…
- How to Extend a Dropdown in Google Sheets: Full GuideTo extend a dropdown in Google Sheets, edit its data validation rule: add choices to the rule or…
- How to Insert a Line in Microsoft Word Online EasilyTo insert a line in Microsoft Word Online, open the document, choose Insert > Shapes, select a line…
- Excel Task List Template: Set Up and Customize YoursAn Excel task list template is a worksheet for recording tasks, owners, due dates, priorities, and progress in…
- How to Double Space in Word Using Your KeyboardTo double-space text in Microsoft Word on Windows, select the text or place the cursor in the paragraph,…
- Conditional Formatting: Highlight Duplicates in ExcelYes. In Excel for Microsoft 365 on Windows, select the cells to check, then choose Home > Conditional…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.