OnePager is the leading project reporting tool, and works with with either Microsoft Project or Excel to build hourly project timelines:
These instructions are geared towards Microsoft Project users. If you are an Excel user, please read this article on how to build hourly project timelines from Excel instead.
OnePager can also be used to build hourly Gantt charts, if that's what you are looking to do instead of a timeline.
How it Works
Begin with your Microsoft Project schedule. Your project is probably more complex than this, but we'll keep it simple in this example. Notice that all tasks are scheduled on the same day--just at different times:
If you don't have an hourly Microsoft Project plan, feel free to download ours to follow along with this example. Below, you will find a sample Microsoft Project plan with hourly tasks, plus a OnePager template (*.tat) that will automatically format your timeline to show hourly units. Please save BOTH files to your Downloads folder or to your Desktop.
Import your project plan by clicking the OnePager button on Microsoft Project's Add-Ins tab. Don't have OnePager? You can download a free trial. In this example, we'll bring in all five tasks, but if you have a larger plan, you can pick and choose which items you actually want to show.
On the start screen, click NEW to start creating a new project timeline, then go to Change > BROWSE FILES to select the Hourly Project Timeline - MSProject template that you downloaded in the first step:
- Click the Create new chart button to create your hourly project timeline:
This hourly project timeline features:
- All project tasks lined up left-to-right in a single timeline instead of a Gantt chart
- A unique color for each task, or each type of task
- A detailed time axis showing the hour and quarter hour
OnePager is the best way to create a project timeline with details down to the hour, down to the minute, or even down to the second. OnePager connects easily with MS Project or Excel, so you don't need to build a timeline from scratch if you already have your project plan in another application.
Get started today by downloading a free trial.15-Day