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
Bookmarks