Bar chart to show time

[sbaily]

hi all

i have date (see below) and i want to display this in a barchart. How do i do this?

Column A
Start time
08:30

Column B
Pt arrives
09:00

Column C
Patient seen
09:30

Column D
Patient left
10:20

Column E
end time
11:00

I want to show block of colour on the graph for each stage, the start being 8:30 and end being 11:00. the gaps will be shown in a different colour so i can show wasted time

thanks

 

[Jon Peltier]

You want a stacked bar chart. The first bar goes from 0 to 8:30, and is formatted with no fill, so it is invisible. The second bar, stacked on the first, has a length of 9:00 minus 8:30, or 0:30. The third bar has length 9:30 minus 9:00, or 0:30. The fourth is 10:20 minus 9:30, or 0:50, and the last is 11:00 minus 10:20, or 0:40. These can all be computed with simple formulas.