| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leaving Cell Blank.
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 "####"?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif function leaving a blank cell when criteria not met | Excel Worksheet Functions | |||
| Leaving a cell blank | New Users to Excel | |||
| Leaving a cell blank when there is an error message - HELP | Excel Discussion (Misc queries) | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
| prevent a user leaving a blank cell in excel2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
