Time Periods Chart Question

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

A guy from 1997 has the exact same question I do now... hopefully
someone can answer it (because he had no responses back then!)... I
am
gonna repost his question:

I am trying to plot a chart containing data similar to that shown
below, without much success:


Sprinkler OnTime OffTime
Front 0815 0845
Front 1445 1600
Front 1700 1730
Back 0900 0930
Back 1800 1830
Left 1100 1115
Right 1130 1215
Right 1900 1930
Right 2000 2030


I'd like to see a graph with four (discontinuous) horizontal lines,
each line corresponding to one of the sprinklers. The X axis is
plotted
from 0000 to 2400, and each line is visible when the sprinkler is on.
 
Ok, so I kind of have it... follow-up question:

Say that Task one has three seperate time periods... Is there a simple
way to get all those on the same horizontal line instead of beneath
each other as seperate instances? Or is this a matter of organizing
the data?
 
Say that Task one has three seperate time periods... Is there a simple
way to get all those on the same horizontal line instead of beneath
each other as seperate instances? Or is this a matter of organizing
the data?
Click to expand...

This is how it needs to look:

Sprklr On1 Off1 On2 Off2 On3 Off3
Front 08:15 00:30 06:00 01:15 01:00 00:30
Back 09:00 00:30 08:30 00:30
Left 11:00 00:15
Right 11:30 00:45 06:45 00:30 00:30 00:30

Each period is the *difference* between two times, so you will use the
original data to subtract each time from the time just before it.
 
Back
Top