Hello,
I have a data set of water temperatures in a river which were taken every 15 minutes for a year. I'm trying to calculate the average water temperature for each day of the year. After that, I would like to calculate seasonal averages.
I have tried to use formulas, but they didn't work for me, and a pivot table but it doesn't seem to be working either. I am not experienced enough to figure out what isn't working and why. Any advice will be greatly appreciated!
P.S. I have also tried to format the dates to be dates instead of text but it didn't work. Is it a problem?
Bookmarks