Hello All,

Any help you can provide would be greatly appreciated. I have a boat load of data (temp & rel humidity) that is logged every second or sometimes 2 seconds and I'd like to make a formula to get the average every five minutes in order to correspond it to other data and to plot.

I think I need to create a formula based on the time stamp since every five minutes the number of rows of data is not consistent. An example of the data is attached.

Cheers,

Kyle


seconds to 5 min.xlsx