I have some time series data (every hour) but I need my data to line up to a
time series of every 15 minutes. Its from March to November its alot of data
not to have a short cut for. :) Thanks

For example: (what I have)
Time data
3/1/2009 0:00 99.12
3/1/2009 1:00 99.07
3/1/2009 2:00 99.06
3/1/2009 3:00 99
3/1/2009 4:00 98.98

But I need to copy the known data cells 99.12 into all the 0:00 times,
99.07 into 1:00 etc etc

Time Data (what I need)
3/1/2009 0:00 99.07
3/1/2009 0:15 99.07
3/1/2009 0:30 99.07
3/1/2009 0:45 99.07
3/1/2009 1:00
3/1/2009 1:15
3/1/2009 1:30
3/1/2009 1:45
3/1/2009 2:00
3/1/2009 2:15
3/1/2009 2:30
3/1/2009 2:45
3/1/2009 3:00
3/1/2009 3:15
3/1/2009 3:30
3/1/2009 3:45
3/1/2009 4:00