mardi 26 juin 2018

Use "if" function to identify specific hours

I have an excel table (Attached picture)enter image description here . 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:

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

error message: contain many conditions

Aucun commentaire:

Enregistrer un commentaire