C
Chris J Denver
Hi newsgroup,
I have got a spreadsheet with 10 minute data as follows:
Timestamp;Value
01/01/12 00:00; 12
01/01/12 00:10; 10
01/01/12 00:20; 11
....
I would like to average this data into half hourly as follows
Timestamp;Value
01/01/12 00:30; 11
and am trying to write a macro to do this. Now this would be easy if
there were always three 10min data points to average, but the problem
is that often there is data missing, so instead there could be only 2,
1, or no 10min data points within one 30min timeframe. I would need
the macro to read the timestamp (MS Office format) and based on this
write averages for each 30min timeframe. And this is what I can't sort
out how to do...
Any help would be greatly appreciated!
Many thanks,
Chris
I have got a spreadsheet with 10 minute data as follows:
Timestamp;Value
01/01/12 00:00; 12
01/01/12 00:10; 10
01/01/12 00:20; 11
....
I would like to average this data into half hourly as follows
Timestamp;Value
01/01/12 00:30; 11
and am trying to write a macro to do this. Now this would be easy if
there were always three 10min data points to average, but the problem
is that often there is data missing, so instead there could be only 2,
1, or no 10min data points within one 30min timeframe. I would need
the macro to read the timestamp (MS Office format) and based on this
write averages for each 30min timeframe. And this is what I can't sort
out how to do...
Any help would be greatly appreciated!
Many thanks,
Chris