Turning hourly data into daily

Hi all,

It has many years since I last used Excel and I cannot remember how to do a thing.

I have a bunch of data that is in an hourly format but I need to do an investigation on it per day.

I need to turn it into Open, High of the day, Low of the day, and close for each day.

I am pretty stuck so any help would be great