Time Series and Creating data points within a series
 

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.

Time Series and Creating data points within a series
 

Check out your other post.

Pete

On Nov 30, 6:39*pm, Cristal wrote:
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.

Time Series and Creating data points within a series
 

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!
--
Daryl S


"Cristal" wrote:

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.