On Tue, 13 Oct 2009 18:17:12 -0700 (PDT), Debbie
wrote:

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

What if C86 is EQUAL to 12?

so either:

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

or

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

--ron