• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gantt Chart using dates and 24 hour time clock

Convivencia

New Member
I need to create a Gantt chart to visually show how long it took to perform certain processes of a project showing the hours and the days. All examples I've found are for more simple time periods (i.e. days or hours, but not both). Users want to enter date, start time, and finish time. NONE will ever overlap, they can't have done the next step until the first step was completed. So the graphs would show the dates across the top, the processes, in order, down the side. In the below, there is a weekend in there.

What I currently get (obviously not working)

upload_2016-9-27_15-23-23.png

Any suggestions or directions to previous threads?
 
When making a Gannt Chart you have to specific the Start as a Date & time and then the duration as Times

Now Dates are just integers and times are decimals 0 to 1 but multiple days are simply a combination eg two and a half days = 2.5

So using two helper columns
upload_2016-9-28_10-17-46.png
Note the Major Gridlines are set at 1 = 1 day
Minor Gridlines are set at 0.25 = 6 hrs
 

Attachments

  • Gannt Chart.xlsx
    14.8 KB · Views: 46
Or as per your original layout
upload_2016-9-28_10-22-47.png
 

Attachments

  • Gannt Chart.xlsx
    15.1 KB · Views: 36
Back
Top