i have a time series in which a varying amound of values are recorded per day. I would like to compute the average per day.


here is the dataset for reference: http://harvardforest.fas.harvard.edu....html?id=hf006 , sheet name: hf006-03: autochamber

I have tried to work with if-statements to define when one day stops and the next ends, but I would have to make a second one to define the range and now I am stuck. I have not found any other good solution in forums, please help.


Thanks!

Attached Images

Screen Shot 2016-11-11 at 14.48.27.png (102.1 KB, 10 views)