Result function is not working correctly (IF & TEXT )

[Emil85]

Hi guys,

Could you please help me to solve following issue:

Main idea is to output some result. If the result is OFF, want to show OFF, and IF the result is Time, to compare 2 tables and to show time at once.
Also if the boxes are empty I would like to have empty result.

OFF functions is working how I expected.
Attached you SS to show you what have I mean.
Annotation 2019-10-08 171701.jpg


Code: =IF(F5="off","OFF",IF(G5="off","OFF")&TEXT(F5,"hh:mm")&" - "&TEXT(G5,"hh:mm"))

Thanks in advance,
Emil

[Roel Jongman]

Try

=IF(OR(F5="off",G5="off"),"OFF",TEXT(F5,"hh:mm")&" - "&TEXT(G5,"hh:mm"))

Or closer to your formula

=IF(F5="off","OFF",IF(G5="off","OFF","")&TEXT(F5,"hh:mm")&" - "&TEXT(G5,"hh:mm"))

[Emil85]

Thank you Roel for your support