How can I choose multiple lines contain specific hours?

[Kwnstantinos_M]

Hello


Column A Column B

1/1/2016 12:00:00 am	yes
1/1/2016 3:00:00 am	yes
1/1/2016 6:00:00 am	yes
1/1/2016 9:00:00 am	yes
1/1/2016 12:00:00 pm	yes
1/1/2016 3:00:00 pm	yes
1/1/2016 6:00:00 pm	yes
1/1/2016 9:00:00 pm	yes
2/1/2016 12:00:00 am	yes
....etc

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 109px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

yes

<tbody>
</tbody>

I have the above table. I want to find which cells (rows) contain specific hours. To do so I used the if function:

=IF(B2=HOUR("12:00:00");"xx";"yes")

The outcome was not correct. As you can see the outcome was "yes" corresponding to false.. What is the problem?

In addition, I tried to embed the "and" function, in order to select multiple hours, but the excel prompt error message. The formula I tried in cell B2 is:

=IF(B2=HOUR(AND("12:00:00";"3:00:00");"xx";"yes"))

message: contain many conditions

 

[mumps]

Try:
=IF(HOUR(B2)=12,"xx","yes")

=IF(OR(HOUR(B2)=12,HOUR(B2)=3),"xx","yes")

 

[Kwnstantinos_M]

Perfect!! Thank you very much!!

 

[mumps]

You are very welcome.