Create Gantt Chart from the following excel sheet to produce the following:
I want to know the following:
Which vehicles are drivers are double booked with clients
Which end locations also coincide with start locations - best to indicate by a matter of hours
I would like to see the timeline across the top with the clients on the left and the vehicles booked highlighted by colour unique to each vehicle and the same for the drivers (colours per driver.
I would also like to see the difference between the Collection Date / Collection Time / End Date / End Time and the Depart Office Date & Time and Return Office Date & Time, different colours can be used for that.