Hiding Formula Results Until All Data is Entered.

[cabbagepulley]

Hi...I'm working on a spreadsheet that tracks time spent on breaks at work. I have two buttons, OUT & IN, that displays the current time in the cell next to it...in this case, OUT displays in B4 and IN displays in B5...my formula in B6 subtracts OUT from IN and displays the result in a number format. Currently, the formula in B6 is =INT((B5-B4)*1440).

However, when I enter the first item (OUT time), my total in B6 shows -6.2E+07 before the IN time is entered...once entered, it shows the correct result. I also have a sort of under/over formula in B7, which is =IF(B6<=30,30-B6,B6-30) that is showing 61554667 with only the OUT time being entered. I'd like to hide these results in B6 and B7 until the IN time in B5 is entered, after which all will calculate normally. Thanks!

 

[Joe4]

Wrap the formula in an IF statement that checks to make sure that both B4 and B5 have values (and if not, return blank), i.e.
=IF(OR(B4="",B5=""),"",your formula here)

 

[cabbagepulley]

Thank you very much...worked like a charm.

 

[Joe4]

You are welcome!