Yes—an hourly Gantt chart template in Excel can be built with one row per task, one column per hour, and conditional formatting to show each task as a bar. Put task start and finish date-times in separate columns, create an hourly timeline across the sheet, then apply a formula-based formatting rule to the grid; this gives you a reusable schedule you can adjust as work changes.
What an hourly Gantt chart shows
A Gantt chart places activities on a timeline so you can see when each one starts, how long it lasts, and whether tasks overlap. An hourly version uses time slots—often one column per hour—instead of days or weeks. It is useful for short schedules such as event setup, a production shift, a training day, equipment maintenance, or a project with tightly sequenced work.
The chart is a visual schedule, not a project-management system by itself. It can show that two tasks occupy the same hour, but it will not automatically know whether that overlap is a conflict. You need to identify the people, rooms, machines, or other resources that cannot be used twice at once, and decide how to handle dependencies and changes.
Set up the worksheet
In a blank worksheet, reserve the first four columns for task information and use the columns to the right for the timeline. A practical layout is:
- A: Task name
- B: Owner or resource
- C: Start date and time
- D: Finish date and time
- E onward: One-hour timeline slots
Use actual Excel date-time values in columns C and D, not text that merely looks like a time. For example, entering a date and time together lets Excel distinguish 9:00 a.m. today from 9:00 a.m. tomorrow. Format those cells with a readable date-and-time format, and keep the finish later than the start. Add task names beginning in row 5, with the timeline headers in row 4.
Choose the chart’s first hour before adding the task bars. If the schedule begins at 8:00 a.m. on a particular date, enter that date and time in E4. This is the start of the first displayed slot, not necessarily the start of the earliest task; you can include a little earlier time for context.
Create the hourly timeline
With the timeline’s first date-time in E4, the next column should be exactly one hour later. With E4 holding the starting date-time and F4 as the next header, enter =E4+TIME(1,0,0) in F4 and fill it right. For example, if E4 is 8:00 a.m. on November 3, 2026, F4 returns 9:00 a.m. on the same date. Each additional column advances by an hour, and Excel’s date-time values continue correctly past midnight.
Format the header cells so readers can tell which day they are viewing. A custom format such as m/d h:mm AM/PM can show both the date and time; a shorter time-only display may be enough for a single-day chart. If you show only the hour, make the date clear in a title or a separate date label, especially when the chart spans midnight or multiple days. Widen columns enough to make the labels legible, or use a compact format and rotate the header text if needed.
Display task bars with conditional formatting
Select the schedule grid, for example E5:AZ30, and in Excel for Microsoft 365 on Windows choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With task names in A5:A30, start date-times in C5:C30, finish date-times in D5:D30, and hourly headers in row 4, use this rule formula:
=AND($A5<>"",E$4<$D5,E$4+TIME(1,0,0)>$C5)
Choose a fill color, confirm the rule, and check that “Applies to” covers the intended grid. The formula checks whether the one-hour slot intersects the task’s start-to-finish interval, and it skips rows without a task name. The dollar signs are deliberate: the task columns stay fixed as the rule moves across the grid, while the hour header changes by column and the task row changes by row.
For a concrete check, suppose row 5 is “Sound check,” C5 is 9:30 a.m., D5 is 11:00 a.m., and E4 is 9:00 a.m. The 9:00–10:00 slot is formatted because it overlaps the task from 9:30 to 10:00; the 10:00–11:00 slot is formatted too. An 11:00–12:00 slot is not formatted, because the task ends at 11:00. This overlap approach is useful when starts or finishes are not aligned to the hour. It signals that some part of the hour is occupied; it does not claim the task lasts for the entire hour.
In Excel for Mac, the conditional-formatting rule is available through the Home tab as well, though the dialog appearance may differ by version. In Excel for the web, conditional formatting is also available, but some advanced editing options can vary; check the rule’s formula and range after opening a workbook created elsewhere.
Enter and check schedule data
Use one row per activity and keep the schedule’s level of detail consistent. If a task takes 90 minutes, record its actual start and finish rather than rounding both values to whole hours. The overlap rule will color the relevant slots. If you use rounded times instead, be clear that the chart is an estimate; rounding can hide a short handoff or make work appear to overlap when it does not.
Before sharing the chart, review the following:
- Every task has a name, a start, and a finish.
- Finish times occur after start times, including for tasks that cross midnight.
- All date-times belong to the intended day or days.
- The timeline begins early enough and extends late enough to show the whole schedule.
- Overlapping tasks have been reviewed against owners and shared resources.
A blank or mistyped date can produce a misleading bar or no bar at all. If a task does not appear, first check that its start and finish cells contain date-time values, that the rule applies to its row, and that its time falls within the visible timeline. Also check for a finish time entered on the wrong date: a task that starts late at night and ends after midnight needs the finish date to be the following day.
Make the template easier to read and reuse
Keep the input area visually distinct from the timeline. For example, use a subtle fill for the task-information columns and a different color for formatted bars. Add a clear schedule title, the date covered, and a small legend if colors have specific meanings. Avoid relying on color alone to communicate status; a separate status column with labels such as Planned, In progress, or Complete is easier to interpret when printed in grayscale or viewed by someone with color-vision differences.
To reuse the sheet, keep the conditional-formatting rule and timeline structure in place, clear old task values, and enter the new schedule. Extend the rule’s “Applies to” range if the new plan has more rows or hours. Consider converting the task list to an Excel table through Home > Format as Table if you want a structured, filterable list; the hourly grid still needs to be sized and formatted for the time span you intend to display.
For a longer schedule, a column per hour can make the workbook very wide. You might split the plan into separate day sections or worksheets, or display fewer hours at once. Freeze task labels while scrolling by selecting the appropriate cell and using View > Freeze Panes; the exact choice depends on which rows and columns you need to keep visible.
Choose the right time scale and understand the limits
Hourly detail is helpful when the order and timing of work within a day matter. It is usually excessive for a project that will run for months, where daily or weekly columns make dependencies and milestones easier to see. A 24-hour view also takes many columns, and a multi-day hourly chart can become difficult to scan or print. Pick the smallest time unit that helps someone make a real scheduling decision, rather than adding detail simply because the spreadsheet permits it.
An hourly chart in Excel is a good fit for a small, controlled schedule that needs a flexible visual overview. Dedicated scheduling or project-management software may be more appropriate when multiple people need to edit simultaneously, tasks depend on one another, resources must be leveled, or updates need to be tracked and audited. Excel can support a useful plan, but it does not automatically resolve resource conflicts or keep every copy of a workbook synchronized.
Common mistakes to avoid
- Using text instead of date-times: A value that looks like “9 AM” may be text and will not compare reliably with a real Excel time. Enter a valid date and time, then apply cell formatting.
- Confusing a slot with a task duration: A colored 9:00–10:00 cell means the task overlaps that slot under this rule; it does not mean the task lasts exactly one hour.
- Leaving out the date: Time-only entries are ambiguous across days. Include dates for schedules that cross midnight or span more than one day.
- Forgetting the rule range: Newly added rows may have no bars if the conditional-formatting range stops above them.
- Assuming overlap always means a problem: Two tasks may occur at once if they use different people or equipment. Add a resource column and review conflicts in context.
Frequently Asked Questions
Does Excel have a built-in hourly Gantt chart template?
Excel’s available templates can vary by version and installation, and a standard Gantt template may use days rather than hours. You can adapt one, but a task table, date-time headers, and conditional formatting are a straightforward way to build an hourly view directly in a worksheet.
Can an hourly Gantt chart show tasks that start at half past the hour?
Yes. Enter the actual start and finish date-times and use the interval-overlap rule described above. A task from 9:30 to 11:00 will appear in both hourly slots it touches, even though it does not occupy all of the first slot.
How do I show a task that runs past midnight?
Enter the start with its correct date and the finish with the following date. For example, a task from 11:00 p.m. to 1:00 a.m. needs a finish date one day later. Include dates in the displayed timeline so the two hours are not confused with the next day’s earlier schedule.
Can I make the bars update when I change a task time?
Yes. Conditional formatting recalculates when you edit the start or finish date-time, provided the edited cell is part of the rule’s references and the relevant time slots are within the formatted range. If bars do not change, inspect the rule’s formula and “Applies to” range.
Should I use 30-minute columns instead of hourly columns?
Use half-hour slots when that precision changes how you assign work or spot conflicts. The same approach applies with a half-hour increment, but the chart doubles its time columns for the same span. If hourly visibility is sufficient, hourly columns are usually easier to maintain and read.
Related
- Find Same Names in Two Excel Columns
- FIND in Excel: Syntax, Examples, and Common Errors
- Find the Max Date in Excel With Multiple Criteria Easily
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Horizontal Line: Add a Constant or TargetTo add a horizontal target or constant line to an Excel chart, add a new data series whose…
- How to Insert a Line Graph in Word: A Step-by-Step GuideTo insert a line graph in Word, select Insert > Chart > Line, choose a line-chart style, and…
- Pivot Tables in Microsoft Excel: How to Create and UseA PivotTable in Microsoft Excel summarizes and reorganizes a larger data set so you can compare totals, counts,…
- Excel Power Pivot Table Tutorial for BeginnersIn Excel for Microsoft 365 on Windows, enable Power Pivot, add your data tables to the workbook Data…
- Power Pivot in Excel 365: What It Does and How to Use ItYes—Power Pivot is available in Excel for Microsoft 365 for Windows when your Excel license includes the feature.…
- Fed Reserve Balance Sheet Graph: Data and How to Read ItThe official Fed balance sheet graph is available on FRED: its WALCL chart tracks the Federal Reserve’s total…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.