View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
 
Posts: 298
Default 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.