Create a Gantt Chart for Hours in a Day

Well this definitely didn't work for me.

Could you advise how I could use this example, but to show time zone overlap between team members?

Excel complains that my formula is incorrect and I am doing exactly what you are doing. I can't figure out what I am doing wrong

Makes no sense In my opinion to have the E1 in the formula should be both D1.

Can you please share a video, how to make chart similar to Gant chart with a time slot of 1 hr with a duration of an activity in power bi. Like employe login / logout ( date time column). Is there any chart which can plot hour slot duration of an activity, like a Gant chart in power bi.

How do you do the it 30 min increments?

Greetings! This is almost exactly what I need, there are just two functions missing. How can I make this span over 24 hours with multiple dates and also track multiple times per day that are not sequential? I have scoured all over the internet to find a Gantt chart to track my sleep. I have been filling one out manually for years, but it would be really nice to be able to just input the times when I go to bed, wake up, or take naps throughout my day. Sleep tracking is becoming quite a trend! Might get a handful of views if you wanted to make a video surrounding that! Feel free to reach out to me, and I can give you the template I have been working with for inspiration! Thanks again for all your videos!!!

very useful but has an issue after 12am. can yo do a video on that?

Why is this so difficult. I just want to make a simple Gantt chart, not build a while damn website. 😒. Thanks for the video though. I was able to follow until Excel started demanding damn formulas.

Thank you for this video, simple and useful. well done.

Doug, I need to create this on a 24 hr. cycle where some employees work an overnight shift. i.e. 7pm-7am. The logic in your code will not fill the correct cells. My times across the top start with 7am and end with 6am. When using the start/stop times 7pm and 3am, the only cell to be filled in is 6am. using 12am-8am, the only cells shaded are 6am and 7am. How do I adjust accordingly. I suppose a question to ask would be at what point of the day is 2am considered more than 7pm or is it less than 3am because when you work an o/n shift it can be both.

This worked perfectly in google sheets as well. Thank you so much!

Thank you for the video! Could you do an update with the latest 2020 Excel version 16.41? I was following along but when it got to New Formatting Rule under Conditional Formatting, the new Excel version looks very different and I wasn't able to complete the tutorial. Thanks!

Hello, Any solutions for the overnight time stamp. Since the formula does not takes AM after PM, can we add another condition formatting or divide the clock time after midnight or do something that can result the overnight hours?? Please assist.

Awesome explanations and very useful.

Pmts tree
p

Pmts tree
By p

Great video! I ran into a problem with my circumstances. My schedules work day runs from 7am-4am the following day, and there are several people that span over the midnight hour. Those that do break the rule since excel sees 0100 as less than 2300. Any help with fixing this issue? Thanks!

How can I make this work for a 24 hour clock for 24 hours a day?

this is great but can you have Name 1 come to work from 8am -10am then come back from 11 am - 2 pm
I am trying to find a chart to draw up an event program where multiple events take place during same time periods and at separate times

Thank You!