Need Formula That Finds the Max and Min

Hello,
I need help creating a formula that finds the Max value of the High column and the Min value of the Low column everyday between 2:00 PM and 2:15 PM (14:00 to 14:15). So the formula would scan the columns containing the dates, times, highs, and lows and would find the 1st instance where 2:00 PM and 2:15 PM (14:00 to 14:15) appear. The formula would then list the Max High and the Min Low between those two rows.

The workbook where the formula needs to be entered contains data that is constantly shifting and updating so the formula has to be based upon the 14:00 (2:00 PM) and not the number of rows because the 14:00 (2:00 PM) row won’t always be in the same place.

See the attached spreadsheet for a better explanation. There are two examples of what I need on one sheet to give an example of how the data can shift.

Thank you in advance for any and all help.

hi artiststevens. another solution. array formula:
=MAX((B2:B152=H152)*(C2:C152>=14/24)*(C2:C152<=I152)*E2:E152)

=MIN(IF(B2:B152=H152,IF(C2:C152>=14/24,IF(C2:C152<=I152,F2:F152))))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.