Column A = time formatted in military time : 9:50
Column B= “Include” if time is between 7:59 (i.e., 7:59AM and 17:59 (i.e., 5:59 PM). If outside those parameters, “” in Column B.
This is my formula:
=IF(AND(A511>TIMEVALUE("7:59:00"),A511<TIMEVALUE(" 17:59:00")),"Include","")
The return value in Column B is “” when the time is within the parameters. The return value should be “Include”.
Need help with the formula