Having trouble with =IF formula

[CLRead]

Hello All,
Would like to see if someone can help me with the following issue:

I am comparing the information typed into cells D61, 62, 63, 64, 65 to the static information in cells C61, 62, 63, 64, 65.

This is how the static information appears in the C cells:
C61 has 2:00
C62 has 3:00
C63 has 4:00
C64 has 8:30
C65 has 10:30

I used =IF(D61<=C61,"YES","NO") in the equivalent E cells and copied it down to E65 so if the manually entered info in the D cells was equal to or less than the C cells I would get YES and if it was greater than I would get a NO.

Works perfectly on all except when comparing D65 to C65. As long as anything between 10:00 and 10:30 is entered I get a YES but if anything else is entered I get a NO even when it is less than 10:30. All info is formatted as text.

 

[markmzz]

Hi!

Try the formulas below:

=IF(--D61 <= --C61,"YES","NO")

or

=IF(TIMEVALUE(D61) <= TIMEVALUE(C61),"YES","NO")

Markmzz

 

[jtakw]

The BEST way is to correct the info and change them to Formats like General, Number, Time, etc., but if you can't or don't want to do that, then this might work:

Book1
	C	D	E
61	2:00	1:00	YES
62	3:00	1:30	YES
63	4:00	4:35	NO
64	8:30	8:45	NO
65	10:30	9:59	YES
Sheet26

Cell Formulas
Range	Formula
E61	=IF(TEXT(D61,"hh:mm")+0<=TEXT(C61,"hh:mm")+0,"YES","NO")

 

[CLRead]

Hi!

Try the formulas below:

=IF(--D61 <= --C61,"YES","NO")

Markmzz

This works! Appreciate the help!

 

[markmzz]

This works! Appreciate the help!

Glad to help and thank you for the feedback.

Markmzz