Discontinuous timeseries for Precipitation Data

03/11/2014 13:30  0.00
03/11/2014 13:45  0.00
03/11/2014 14:00  0.00
03/11/2014 14:15  0.00
03/11/2014 14:30  0.00
03/11/2014 14:45  0.00
03/11/2014 15:00  0.00
03/11/2014 15:10  0.01
03/11/2014 15:15  0.00
03/11/2014 15:30  0.00
03/11/2014 15:40  0.00
03/11/2014 15:45  0.00
03/11/2014 16:00  0.00
03/11/2014 16:15  0.00
03/11/2014 16:30  0.00
03/11/2014 16:45  0.00
03/11/2014 17:00  0.00
03/11/2014 17:05  0.00
03/11/2014 17:10  0.00

I have discontinuous time series precipitation data but some days, the time step is 15 minutes and for some days the time steps is 5 minutes. I need either 5 minute time step data or 15 minutes. I tried to use linear interpolation but results are not correct. Any idea to generate constant time step data? Doing it on excel is very time consuming.Because data is for two years (5 and 15 minutes time step)

[per isakson]

• "results are not correct" &nbsp In what way not correct?
• I deleted your identical question of yesterday.

[Image Analyst]

What form is your time data in? A string? A serial date (which is a number)? Can you attach it so people can try things?

[ammara talib]

I have attached the data. data is serial data. Results are wrong means when I interpolated the data so that I have all data in 5 minute time step then I aggregated the data on daily basis and compare it with the daily original data then data does not match. Is there anyway I can make this discontinuous data to continuous 5 minute or 15 minute time step.

[ammara talib]

data is attached

[per isakson]

One has to both [Choose file] and [Attach file]. If one only chooses a file Answer will quietly ignore the effort. I guess that happened to you, since I cannot see an attach file.

[ammara talib]

I attached it now. Sorry about that.

[per isakson]

• "precipitation data" &nbsp In what unit of measurement?
• "results are not correct" &nbsp How?

[ammara talib]

units are inches. I have separate data for daily precipitation. I used interpolated time series (5 minute time step) and then accumulate it on daily basis then compared it with the daily data (original daily data). data does not match.

[per isakson]

"data does not match" &nbsp Isn't that what one should expect?

Assume you have 24 hours of constant rain of 0.01 inches per 15-minute. That will result in 60/15*24*0.01 = 0.9600 inches for that 24-hour period.

Now interpolate to get 5-minute values. Each 5-minute value will be 0.01 inches. The sum for the 24-hour period will now be 60/5*24*0.01 = 2.8800 inches.