Hello,

I am trying to do some analysis of vehicle availability by hour of the day / day of week for my organisation. The vehicles are not available all the time as they require four trained staff to be working to man them. When the required staff are working the system books the vehicle as 'available'.

I can extract the availability data into Excel as the following columns:

Vehicle reference number
Availability from (date and time)
Availability to (date and time)

We have a number of vehicles listed in one spreadsheet I would like to identify the % that each vehicle is available for each hour of the day / day of week based on one year of data.

I was going to present the information in a matrix with days on the X axis and hours on the Y for each vehicle.

If anyone could give me some advice on the best way to tackle this I would greatly appreciate it.

Pip