Excel: Charting elapsed time?

[TheElephantMan]

Hi, all.

I've got some data points that show the start and end times of a few of our nightly processes, broken down by date:

Date |P1Start|P1End|P2Start |P2End|P3Start |P3End
1/2/2008|18:00 |20:00|22:00 |00:00|02:00 |04:00
1/3/2008|17:00 |19:00|21:00 |23:00|01:00 |03:00
...

I'm trying to make a bar chart, where each bar represents a single day, and the "body" of the bar represents the range of time that each of the three processes takes, with a gap between end and start times between processes.

Is it possible to make such a chart in Excel? How would I go about doing it?

Thanks in advance,
TEM

 

[SkipVought]

Hi,

FIRST, each TIME must ALSO include DATE.

SECOND, having included the date part with the time, calculate the durations AND the lag time between P's. You will end up with...
[tt]
Dur1 Lag12 Dur2 Lag23 Dur3

[/tt]
in your case ALL 2 hours.

Then you plot P1Start and the calculated dirations and lag times. The BORDER & FILL for the FIRST series will be NONE. Also edit the y-axis and REVERSE the values.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[SkipVought]

oh yes, and each Lag span has no fill or border.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[TheElephantMan]

Hi, Skip!

This is great; thanks for the help. I do have another question, though; how do I calculate the difference in time and the lag? When I create a formula with an end time minus a start time, I get weird results:

P1Start P1End P1Dur
1/2/08 18:00 1/2/08 20:00 1/0/00 2:00

Thanks,
TEM

 

[SkipVought]

Your result is not wierd at all. faq68-5827.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]