Time Series and Creating data points within a series

[Cristal]

I am trying to change hourly data to include data points for every 15
minutes.

What I have What I need
Time Data Time Data
3/1/2009 0:00 99.12 3/1/2009 0:00 99.12
3/1/2009 1:00 99.07 3/1/2009 0:15 99.12
3/1/2009 0:30 99.12
3/1/2009 0:45 99.12
So, 1) I need to create data points for time and time within my existing data
2) I need to copy data that occurs in one cell (99.12 for example b2) four
times before copying the next value (00.07 for example b3)

My data is for 9 months, too time intensive to do by hand.

 

[Pete_UK]

Check out your other post.

Pete

 

[Daryl S]

Cristal -

Assuming this is a one-time conversion, make a copy of your spreadsheet and
do the following:

Assume your data is in columns A and B.

In column C, add a formula like this:
=B16+1/(24*4)
This will add 15 minutes (one day divided by 24 hours in a day divided by 4
15-minute intervals in an hour).
Copy column D to column E.

Now you have the 15-minute data you need, so you can copy/paste special |
values these records in columns C and D into your original spreadsheet.

Change the formula in column C for the 30-minute time:
=B16+1/(24*2)
Copy/paste or drag the formula down - no need to alter column D.

Copy/Paste Secial | Values into your original spreadsheet.

Change the formula in column C for the 30-minute time:
=B16+3/(24*4)
Copy/paste or drag the formula down - no need to alter column D.

Copy/Paste Secial | Values into your original spreadsheet.

Hope this helps!