I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z3 = 8:00