excel - Maximum values per day from data with different dates -

I get data on different times at different times, for example:

< Pre> dateTimeRead (YYYY-MM-DD HH-mm-ss) rain_value (mm) air_pressure (hpa) 1/2/2015 0:00 0 941.5675 1/2/2015 0:15 0 941.4625 1/2 / 2015 0:30 0 941.3 1 / 2/2015 0:45 0 941.2725 1/2/2015 1:00 0.2 9 41.12 1/2/2015 1:15 9 9 40.8625 1/2/2015 1:30 940.7575 1/2 / 2015 1:45 0 940.6075 1 / 2/2015 2:00 0 9 40.545 1/2/2015 2:15 940.27 1/2/2015 2:30 0 940.2125 1/2/2015 16:15 940.625 1/2 / 2015 16:30 0 9 40.6 9 1 / 2/2015 16:45 0 9 40.6175 1/2/2015 17:00 940.635 1/2/2015 19:00 941.9975 1/2/2015 20:45 0 942.7925 1 / 2/2015 21:00 942.745 1/2 / 2015 21:15 942.6325 1/2/2015 21:30 942.735 1/2/2015 21:45 942.765 1/2/2015 22:00 0 7/30/1902 1 / 3/2015 2:30 0 941.1275 1/3/2015 2:45 0 941.125 1/3/2015 3:00 0 9 40.955 1/3/2015 3:15 0 941.035

There are dates with unavailable time stamps

I read rain_value (mm) from these readings?

A standard standard array formula to provide a pseudo-Maxif function Style, but I like using INDEX and want to enter it as a standard formula.

with date set in F3 For, there is a formula in G3,

  = MAX (index (($ A $ 2: $ A $ 999> = $ F3) * ($ A $ 2: $ A $ 999) & lt; (F3 + 1) * $ B $ 2: $ B $ 999,))  

A CSE array formula for the same thing would be something like this,

  = MAX (IF ($ A $ 2: $ A $ 999> = $ F3, if ($ A $ 2: $ A $ 999 & lt; $ F3 + 1, $ B $ 2: $ B $ 900))  
  +  div>