Compare Time Using If Formula
First Select Any Of The Cell For Output Result.
Apply The Formula '=IF(TIME(11,17,30)=D2,"Yes","No")
Make Sure That Time After 12:00 Hr Is 13:00 As By Default The Time Value Is In 24 Hrs Format. If You Change The Format To 12 Hrs Then It Fine to Have 01;00 Hrs. But Its Vary With Time Formats.
As A Result You Can Choose The Output With If Formula.
That's It: :)