Charting Usage Between 2 Times

[Tofox2]

Hey guys,

I’d like to create a chart with the following data as an example.

08:45 10:00. 3
9:50 11:15. 2
11:15 13:30. 4
13:00 15:00. 1

So it’ll show:
between 8:45 and 09:50 = 3
between 9:50 and 10:00 = 5
between 11:15 and 13:00 = 4
between 13:00 and 13:30 = 5
between 13:30 and 15:00 = 1

I’d really appreciate any help you can give, thanks.

 

[VBA Geek]

You can arrange your data like this and then insert a XY chart with line and no markers and then setting the horizontal axis min to 0.3333333 ( 8 am) and the max to 0.6666666 (4 pm) and the major unit to 0.0416667 ( one hour)