Find maximum measurement taken within an hour

Hello, I have two columns one with the date and time that each measurement was taken and another with the measurement values. I would like to add a column that only shows the maximum measurement taken for each day within an hour. I know that I could create a column that rounds the time down to the nearest hour and find the max using that but I want to find the max within a 60 minute period no matter what part of the hour they fall if that makes sense. I attached a small portion of my data, I would appreciate any help, thanks.

=max(if(a2:$a$40<=a2+3/72,b2:$b$40)) cse

one way with PowerQuery

Originally Posted by tim201110

=max(if(a2:$a$40<=a2+3/72,b2:$b$40)) cse

Sorry I probably should've added this in my post but is there a way to display the max only on the row that it occurs? I added a column to the spreadsheet where I manually put the max values in to show you what I mean.

Try this in C2:

=IF(MAX(IF(FLOOR($A$2:$A$40,1/24)=FLOOR(A2,1/24),$B$2:$B$40))=B2,B2,"")

Array formula, enter with Ctrl+Shift+Enter.