1. Home
  2. Templates
  3. Hourly Gantt chart

Free hourly Gantt chart template

Plan a single day hour by hour: an event, a shoot, a launch or a maintenance window. Type a start time and a duration in minutes and the bar draws itself, in 30-minute slots from 6 am to midnight.

.xlsx · Excel, Google Sheets, LibreOffice · free

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.

TaskOwnerStartDuration
Venue setup and AV checkOps07:0090 min
Registration opensFront desk08:3060 min
Opening keynoteHost09:3060 min
Morning sessionsSpeakers10:3090 min
LunchCatering12:0060 min
WorkshopsSpeakers13:00150 min
Closing panelHost16:0060 min
DrinksCatering17:00120 min
TeardownOps19:00120 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

  1. Set the day start and slot size at the top of the sheet.
  2. Type your tasks, owners, start times (hh:mm) and durations in minutes. The bars appear as you type.
  3. Add a row by inserting it inside the table and copying the row above, so the formulas follow.
  4. 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.