OnePager connects to Excel to help you build hourly project timelines:
OnePager can also be used to build hourly Gantt charts from Excel, if that's what you are looking to do instead of a timeline.
How it Works
- Begin with your Excel project schedule. If you're using Microsoft Project instead of Excel, please read these instructions instead. Notice that all tasks start and finish on the same day, but are scheduled at different times:
You can download this example spreadsheet if you'd like a template for how to set up your own hourly project plan in Excel.
- Import your project plan by clicking the OnePager button on Excel's Add-Ins tab. Don't have OnePager? You can download a free trial.
- On the start screen, click NEW to start creating a new project timeline, then select the "Hourly Timeline" template from the import wizard:
You can download the Hourly Timeline template if it didn't come with your trial. Just save it to your desktop, then click Change > BROWSE FILES to select it.
- Finally, click the Next button, followed by Create New Project View button to create your hourly project timeline from Excel:
This Excel hourly project timeline features:
- All activities aligned left-to-right in a single timeline layout instead of a Gantt chart/waterfall layout
- A unique color for each task, or each type of task
- Text reflecting the name of each task
- A detailed time axis showing the date, hour, and quarter hour. These units can be adjusted as needed if you want to show more or less time detail.
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.15-Day