Right now, I have data that is in 1 minute wind speed and direction (in
degrees) averages. I need to convert it to 5 minute averages (that is the
average from time 0-5min, 6-10min, 11-15 min and so on). I've attempted to
use the text and indirect functions to do this, but it ends up over lapping
(i get averages from 0-5, then 5-9, then 9-13). What kind of code or
functions can I write to make this work?