I have a spreadsheet with over 45,000 lines of information. It is data that was collected every minute for a month.
Column A has the time in hh:mm:ss form, and column B has the data in standard number form.
Now I need to average the data by 1 hour, 3 hour and 24 hour spans. Is there an easy way to do this with a function, such as =AVERAGEIF?