Formula show text base on time value

[asyamonique]

Hello Good Day,
Could you please help me with the formula that will lookup the related column which contains times as 12:00 etc....
And it will write the cell they YES or NO base on time value..
If the time below 12:00 can be shown as text, "YES" ...Above can be "NO"
Many Thanks

 

[etaf]

does this work for you

=IF(A2<=TIMEVALUE("12:00"),"yes","no")

Book1
	A	B	C
1
2	10:00		yes
3	11:00		yes
4	12:00		yes
5	13:00		no
6	14:00		no
7	15:00		no
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(A2<=TIMEVALUE("12:00"),"yes","no")

 

[asyamonique]

Thanks

 

[etaf]

you are welcome

 

[asyamonique]

Hello again,
What instead time value if there is numbers like 500?
Tq

 

[etaf]

=IF(A2<=500,"yes","no")

 

[asyamonique]

Hello again,
If the cell is empty result shows as YES
Is it possible to avoid that error?
Actually there is a below formula on that cell which takes the datas.
If cell is empty without formula its fine.
With formula it shows as YES

=IFERROR(VLOOKUP(CF3,BE:BZ,22,0),"")

Thanks Again

 

[etaf]

=IF(AND(A2<>"",A2<=500),"yes","no")

will give a no for a blank cell

OR
=If(A2="","",IF(A2<=500,"yes","no"))
will not give a result for blank cells