Even date time distribution
 

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.

Even date time distribution
 

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.

Even date time distribution
 

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.

Even date time distribution
 

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.

Even date time distribution
 

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