Using >than

[HappyChappy]

hi would like to use >than to give me a Yes or a No yes and no refers to breaks taken if 8:00 or less needs to show a No if greater than 8:00 needs to show Yes
if blank needs to show blank

C1 is 08:00 d1 needs to display No
C1 is 09:00 d1 needs to display Yes

Thanks in advance

 

[mohadin]

Try

=IF(C1="","",IF(C1>(--"8:00 AM"),"Yes","No"))

 

[HappyChappy]

Try

=IF(C1="","",IF(C1>(--"8:00 AM"),"Yes","No"))

works but defaults to no if no times are entered and i would like to see a blank cell if no times are input

 

[mohadin]

Nop

8:00​	No
9:00​	Yes
10:00​	Yes
18:00​	Yes
0:00​	No

 

[HappyChappy]

Nop

8:00​	No
9:00​	Yes
10:00​	Yes
18:00​	Yes
0:00​	No

instead of 0:00 this cell would be blank therefore the result should be blank also

 

[HappyChappy]

Try

=IF(C1="","",IF(C1>(--"8:00 AM"),"Yes","No"))

thank you for the answer

 

[mohadin]

Some thing like this?

=IF(OR(C1="",C1=0),"",IF(C1>(--"8:00 AM"),"Yes","No"))