Hi I can't get this to work Column K is a formula =IF(OR(H10 ="",H10 = "NULL"),"",H10-F10) and formatted as 37:30:55 example row 10 column K result is 105:09:12
Column C is just text
I want to have the condition met if the hours in K are less than or equal to 104:00:00 AND C equals Red OR Yellow
=IF(AND(TEXT(K10,"hh:mm")<="104:00",OR(C10="Red",C10="Yellow")),"Met",Missed")
Thanks
L
Column C is just text
I want to have the condition met if the hours in K are less than or equal to 104:00:00 AND C equals Red OR Yellow
=IF(AND(TEXT(K10,"hh:mm")<="104:00",OR(C10="Red",C10="Yellow")),"Met",Missed")
Thanks
L