Excel - Gantt Chart by Hour - Episode 1799

Microsoft Excel Tutorial: How to Create an Hourly Gantt Chart in Excel Using Conditional Formatting. Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing how to create a Gantt chart by hour in Excel. This topic was inspired by a question I saw on Twitter, asking how to change the scale to hours in a Gantt chart. I immediately thought of my YouTube video on creating a Gantt chart using conditional formatting, but realized that the question may not have been referring to my video specifically. Nevertheless, I knew it was a topic worth covering in more detail. To start off, we have a Gantt chart with hours along the top instead of dates. To format this, we will use the custom number format and get rid of the minutes to make it more compact. We will also align the numbers vertically and adjust the column width to fit everything on the screen. Next, we will use a formula in conditional formatting to highlight the hours in which an event is taking place. This formula will check if the start time is less than or equal to the hour and if the end time is greater than or equal to the hour. We will then copy this formula and apply it to the entire chart using conditional formatting. But what if an event spans multiple hours? In that case, we want to highlight all the hours in which the event is taking place. To do this, we will use helper rows and columns to convert the times to minutes of the day. Then, we will use a formula to check if the intersection of the start and end times is greater than 29 minutes. However, I found that this method was too slow and came up with a simpler formula using the minimum and maximum values of the start and end times. This formula can also be applied without using the helper rows and columns, making the chart cleaner and easier to read. In the end, we have a Gantt chart that highlights the hours in which an event is taking place, even if it spans multiple hours. This is a useful tool for project management and can be customized to fit your specific needs. Thank you for watching this episode of the MrExcel podcast, and be sure to check out our other episodes for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... Table of Contents: (00:00) Introduction and Sponsorship (00:10) Episode Topic: Gantt Chart by Hour (00:20) Formatting the Gantt Chart (01:00) Building the Formula for Conditional Formatting (02:01) Copying the Formula for Conditional Formatting (02:15) Deleting the Formulas and Adjusting Column Width (03:01) Dealing with Partial Events (03:55) First Attempt at Formula (04:54) Simplifying the Formula (06:50) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Building a Gantt chart in Excel Changing scale to hours in Gantt chart Conditional formatting Converting time to minutes in Excel Creating a Gantt chart without helper rows/columns Formatting hours in Excel Formula for Gantt chart by hour Gantt chart in Excel Highlighting events in Gantt chart Partial events in Gantt chart Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads... Using conditional formatting to create an hourly Gantt chart in Excel.