Not sure what I'm doing wrong. Tried a couple of things but cannot get to work. Trying to remove "######" from cell when time is left blank.
here is formula:
=IF(ISNA(F6-TIME(1,0,0)),"test",(F6-TIME(1,0,0)))
if there is no time entered in cell F6, I'd like it to say "test"