If I understand your table:

Chute Open Time Duration
01B 05:00 2:20
01B 07:20 2:20
01B 08:00 0:40

Open time 5:00 plus (open) duration 2:20 is 7:20, which is the next open
time, so there's no closed duration. Open time 7:20 plus (open) duration
2:20 is 9:40, which comes after the next open time of 8:00.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Songoku wrote:

apologies Jon but I don't follow my first duation is 0?

"Jon Peltier" wrote:


You need all of the data in a single row. Only the first time is
absolute, the rest are durations, so you're plotting 'Start', 'Duration
Open', 'Duration Closed', 'Duration Open', etc.

I was going to reconfigure the data as an illustration, but your first
'Duration Closed' is zero, and the second is negative (open comes before
previous close).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Songoku wrote:

for example

where the graph should display

01B ******** ****** ******
05:00 05:30 06:00 06:30 07:00 07:30 08:00

I get

01B *****

01B *******

01B **********
05:00 05:30 06:00 06:30 07:00 07:30 08:00

I have tried to convert the chute to number however I get the same thing.....

"bj" wrote:



I don't understand the "get duplicate chutes" comment. More info, please?

"Songoku" wrote:



Hi,

I need to create a floating bar graph to show when chutes open and their
durations so for example:

Chute Open Time Duration
01B 05:00 2:20
01B 07:20 2:20
01B 08:00 0:40

problem I am having is that when i go to create the floating bar graph
although the general information is correct i.e time and duration i get
duplicate chutes. I have tried converting these to numbers but have had no
joy..........

any help please.........would be appreciated!!!!