Averaging data on individual dates

[ZochSteveo]

Ok, I had a separate forum post but was unable to find an answer. I was hoping I could start afresh and go again and see if I could find a solution.

Essentially, I have a set of data. Within the data are 5 minute time stamps/intervals for each day commencing on March 31st 2024 and going through until September 30th 2024. As you can imagine, this is a lot of data. Or essentially, 287 points per day, with each time having a corresponding temperature recording. So the time is in one column, say column A, and the temperature values are in column B for example

Is there a way of me averaging the temperature values for each day? I need a quick way of doing this if possible.

 

[Joe4]

Duplicate to: Averaging Data Set

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.