| 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 "####"?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving Cell Blank.
There will definitely be time-out for the day, neverthe less,
try this =IF(B1="","",B1-A1) -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "GEM" wrote: 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 "####"?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving Cell Blank.
Perfect, thanks!!!
"xlmate" wrote: There will definitely be time-out for the day, neverthe less, try this =IF(B1="","",B1-A1) -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "GEM" wrote: 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 "####"?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaving Cell Blank.
Hi GEM
Thank you for your feedback, Glad it work for you. Would you click the Yes button below -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "GEM" wrote: Perfect, thanks!!! "xlmate" wrote: There will definitely be time-out for the day, neverthe less, try this =IF(B1="","",B1-A1) -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "GEM" wrote: 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 "####"?? |
| Reply |
| 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) | |||
Linear Mode
