Just add it to the And function:
IF(AND(F85=--"8:30",F85<=--"9:00",C8612),1,"B")

Regards,
Fred


"Debbie" wrote in message
...
On Oct 13, 9:13 pm, Debbie wrote:
Here is another scenario.

If F85 is greater than or equal to 8:30 am but less than or equal to
9:00 am, then I need it to return a 1, If it is not between 8:30 am
and 9:00 am then I need it to return "B". I have the cell formated as
time 00:00 AM. What am I doing wrong?

IF(AND(F85=8:30,F85<=9:00),1,"B")

The other criteria that it needs to meet is that c86 needs to be
greater than 12 otherwise if less than 12 then "B"