I am adding and subtracting time, simple "=B1-A1" formula, where B1 is OUT
time and A1 is IN time.

Ex.
A1 = 9:00
B1 = 17:00

The answer for "=B1-A1" is 8:00.

My question is this, if I have time entered into A1 and no time entered in
B1 I will get "#####" as a result in the cell where I have my formula set.
How can the cell stay blank without the "####"??