Why doesn’t my Gantt chart work properly in Excel?

Scott Merritt January 7, 2012
Pinterest Stumbleupon Whatsapp

I’ve created a Gantt chart in Excel that automatically fills in working hours. But if the schedule is from 19:00 to 03:30, it doesn’t fill anything in. What is causing this problem?

  1. Anonymous
    January 7, 2012 at 11:17 am

    Advanced Gantt Charts in Microsoft Excel.
    http://peltiertech.com/Excel/Charts/GanttChart.html

    How to Use a Gantt Chart to Schedule Workers
    http://www.ehow.com/how_8570838_use-gantt-chart-schedule-workers.html

  2. Susendeep Dutta
    January 7, 2012 at 9:36 am

    In you Gantt chart,select all the time fields,right click and select "Format cells", and on "Number" tab,set type of date and time by clicking on "Date" and "Time" menu separately and selecting their types by choosing them on right side.