I work for an ambulance service. I wish to track, via a horizontal bar
graph, the call times. Here is how it would be set up:

Cells A1 through AZ1 (as example) equals times (text format to get 4 digits
for time without dropping leading zero), ie A1=0600, B1=0601, C1=0602,
D1=0603...AZ1=1800 (military time). I know I need more cells than A1-AZ1,
but just an example

Cells A2 - A10 siginfiy which ambulance unit, ie A2=Medic 1, A3=Medic 2, etc

Somewhere in the spreadsheet, I have a section that I enter the dispatch
times and the end time of each call. Lets say column BA1:BA10 equals start
times and BB1:BB10 equals stop times.

What I want to do is have the chart section created by the times 0600 - 1800
and ambulance number (Medic 1, Medic 2, etc) fill in appropriately the
timeslot for each call. So if Medic 1 was on a call from 0605 to 0700, the
cells for Medic 1 under those times would fill in. I know this will be a
conditional formatting, but not sure how to have those cells reference the
start/stop array in order to know whether to fill in or not. Any cells that
were not filled in would indicate when the unit was not on a call.

Below is an example of the above, but I use X's to represent the color fill
for a cell

|0600|0601|.....| 0607| 0608| 0609|....| 0615| 0616|....| 0700|
Medic 1 | | | |XXXX|XXXX|XXXX|XX|XXXX|XXXX|XX|XXXX|

Any help greatly appreciated,
Thanks,
Les