It looks like the formula you have written is correct. However, there might be a formatting issue with the cell that is preventing the formula from working as expected. Here are a few things you can try:

1. Check the cell format: Make sure that the cell containing the time value is formatted as "Time" with the correct time format (00:00 AM/PM). You can do this by right-clicking on the cell and selecting "Format Cells". Then, select "Time" from the list of categories and choose the appropriate format.
2. Check the time value: Double-check that the time value in cell F85 is entered correctly. It should be in the format of HH:MM AM/PM. For example, 8:30 AM should be entered as "8:30 AM" and not "8.30" or "8:30".
3. Try using the TIME function: Instead of entering the time value directly in the formula, you can use the
   Code:

   TIME

   function to specify the time range. For example, the formula would be:
   Code:

   IF(AND(F85=TIME(8,30,0),F85<=TIME(9,0,0)),1,"B")

   . This will ensure that the time values are interpreted correctly by Excel.

Hopefully, one of these solutions will help you get the desired result. Let me know if you have any other questions or if there's anything else I can help with!