How can I choose multiple lines contain specific hours?

[Kwnstantinos_M]

Hello


Column A Column B
[TABLE="width: 500"]
<tbody>[TR]
[TD]1/1/2016 12:00:00 am[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 3:00:00 am[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 6:00:00 am[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 9:00:00 am[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 12:00:00 pm[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 3:00:00 pm[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 6:00:00 pm[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]1/1/2016 9:00:00 pm[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]2/1/2016 12:00:00 am[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]....etc[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

****** id="cke_pastebin" style="position: absolute; top: 109px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]yes[/TD]
[/TR]
</tbody>[/TABLE]
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.