What is an hourly Gantt chart?
An hourly Gantt chart is a Gantt chart whose timeline is divided into hours or half-hours instead of days. Each task is a bar that starts at a clock time and lasts a number of minutes, so you can see at a glance who does what, when, and where two things overlap. It is the right format when everything happens within one day and a 30-minute slip matters.
When to use one
- Event day run sheet: doors, talks, breaks, catering, teardown.
- Film or photo shoot: setup, lighting, takes per scene, wrap.
- Launch day: final checks, go-live, emails, social posts, monitoring.
- Maintenance window or IT cutover: backups, migration steps, tests, rollback point.
- Shift planning: who covers which hours on a busy day.
- Wedding day: hair and make-up, ceremony, photos, dinner, first dance.
Example: a conference day
The template opens with this schedule. Rename the tasks and change the times to make it yours.
| Task | Owner | Start | Duration |
|---|---|---|---|
| Venue setup and AV check | Ops | 07:00 | 90 min |
| Registration opens | Front desk | 08:30 | 60 min |
| Opening keynote | Host | 09:30 | 60 min |
| Morning sessions | Speakers | 10:30 | 90 min |
| Lunch | Catering | 12:00 | 60 min |
| Workshops | Speakers | 13:00 | 150 min |
| Closing panel | Host | 16:00 | 60 min |
| Drinks | Catering | 17:00 | 120 min |
| Teardown | Ops | 19:00 | 120 min |
What’s inside the Excel file
The workbook has one Schedule sheet and a short How to use sheet. On the schedule, each row has a task, an owner, a start time and a duration in minutes; the end time is calculated. The grid on the right is drawn by conditional formatting: no macro, no add-in. Two cells at the top control the timeline: the day start (6:00 by default) and the slot size in minutes (30 by default). Set the slot to 15 for a tight run sheet, or to 60 to see a full day and night.
How to customise the template
- Set the day start and slot size at the top of the sheet.
- Type your tasks, owners, start times (hh:mm) and durations in minutes. The bars appear as you type.
- Add a row by inserting it inside the table and copying the row above, so the formulas follow.
- Print it in landscape and pin it on the wall, or share the file. It also opens in Google Sheets: see how to make a Gantt chart in Google Sheets.
Hours for the day, days for the project
An hourly chart is perfect for the day itself, not for the weeks before it. The online Ganttmint editor plans in days and weeks, with dependencies you drag from bar to bar. A good routine: plan the run-up to your event online, starting from the event planning template, and use this hourly sheet for the big day. For a multi-week plan in a spreadsheet, take the Excel Gantt chart template instead.
Questions
Is the hourly Gantt chart template free?
Yes. Download it, use it and share it, for personal or commercial projects.
Can I use 15-minute slots?
Yes. Change the slot size cell at the top of the sheet to 15 and the timeline redraws.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the times and the bars work the same way.
Can a task run past midnight?
The template covers one day. For a night shift, set the day start to the evening, for example 18:00, and the timeline runs into the next morning.
Can I plan in hours in the Ganttmint editor?
The online editor schedules in days. Use this Excel template for hour-by-hour plans and the editor for anything that spans several days.