I've got a single column data series.

I need to associate each element with a date time value for plotting on a
graph.

Only have start date/time and end date/time. How can I get an even
distribution of date time sequence from start to end?
A B
04/07/08 17:00 123
..
..
05/08/08 13:04 345


Need to fill in the gaps in col A

Was thinking something like cell a2 would =(B610 - B1/610) + A1

Not working so far.

Thanks for any help.

Where does "B" come into play? A1 is first time, A610 is last time, then
A2 would be (A$610-A$1)/610+ A1

Rich wrote:

I've got a single column data series.

I need to associate each element with a date time value for plotting on a
graph.

Only have start date/time and end date/time. How can I get an even
distribution of date time sequence from start to end?
A B
04/07/08 17:00 123
.
.
05/08/08 13:04 345


Need to fill in the gaps in col A

Was thinking something like cell a2 would =(B610 - B1/610) + A1

Not working so far.

Thanks for any help.

Bob,

I think that you should be dividing by 609 not 610. With 610 the intervals
are 1:15:09 and cell A609 has a value of 5/8/2008 10:33:42 and the last
interval to A10 is 2:30:18.

Dividing by 609 results in all intervals including between A609 & A610 of
1:15:17

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Bob I" wrote in message
...
Where does "B" come into play? A1 is first time, A610 is last time, then
A2 would be (A$610-A$1)/610+ A1

Rich wrote:

I've got a single column data series.

I need to associate each element with a date time value for plotting on a
graph.

Only have start date/time and end date/time. How can I get an even
distribution of date time sequence from start to end?
A B
04/07/08 17:00 123
.
.
05/08/08 13:04 345


Need to fill in the gaps in col A
Was thinking something like cell a2 would =(B610 - B1/610) + A1

Not working so far.

Thanks for any help.

Thanks folks.

Yes that is what I did. The key was in changing the formats of the columns.

Once changed to number (from date) it worked. I'm a mainframe programmer
and format, to me, doesn't mean anything but the display format, so I never
give format the thought (in the MS world) I need to.

Regards,

Rich

"Sandy Mann" wrote:

Bob,

I think that you should be dividing by 609 not 610. With 610 the intervals
are 1:15:09 and cell A609 has a value of 5/8/2008 10:33:42 and the last
interval to A10 is 2:30:18.

Dividing by 609 results in all intervals including between A609 & A610 of
1:15:17

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Bob I" wrote in message
...
Where does "B" come into play? A1 is first time, A610 is last time, then
A2 would be (A$610-A$1)/610+ A1

Rich wrote:

I've got a single column data series.

I need to associate each element with a date time value for plotting on a
graph.

Only have start date/time and end date/time. How can I get an even
distribution of date time sequence from start to end?
A B
04/07/08 17:00 123
.
.
05/08/08 13:04 345


Need to fill in the gaps in col A
Was thinking something like cell a2 would =(B610 - B1/610) + A1

Not working so far.

Thanks for any help.

You are correct, there are only 609 intervals.

Sandy Mann wrote:

Bob,

I think that you should be dividing by 609 not 610. With 610 the intervals
are 1:15:09 and cell A609 has a value of 5/8/2008 10:33:42 and the last
interval to A10 is 2:30:18.

Dividing by 609 results in all intervals including between A609 & A610 of
1:15:17