Hello there,

I have a question about converting time series with irregular intervals to a series with a regular interval (e.g. 15 minutes). Sometimes the irregular intervals are smaller than the regular (e.g. 1 minute), and sometimes the irregular interval is bigger (e.g. 1 day).
How can I automatically convert the time series to the new interval (15 min).
1. If the time step in column A is smaller than 15 minutes, the data in column B has to be summed in the new time interval
2. If the time step in column A is larger than 15 minutes, the data in column B has to be equally devided over the new time intervals.

I hope my question is clear, also see the attached file below.

Regards from Holland,
Sander
Example.xls