#Value in random cells
 

I have a formula to calculate the hours I work based upon time in and time
out - time in is deducted from time out. Since my time is based on two weeks
and starts on Sunday, ending on Saturday, my formula uses the ISBLANK
function, as I don't always have to come in on weekends. However, I have
random #VALUE! errors in the cells that show the time worked. Most of the
cells show a blank if there is no start time for the day, but I currently
have the value error on Monday and Tuesday of the second week. No matter how
many times I copy/paste from a working cell, or manually type in the formula,
this error won't go away. Any ideas as to what I might be missing? Thank
you.

#Value in random cells
 

From help on error

Correct a #VALUE! error
Occurs when the wrong type of argument or operand is used.

Following this is a list of possible problems for you to check.

The usual cause is text instead of a number.

Check your time entries.


Gord Dibben MS Excel MVP


On Fri, 19 Jun 2009 09:58:01 -0700, Michael
wrote:

I have a formula to calculate the hours I work based upon time in and time
out - time in is deducted from time out. Since my time is based on two weeks
and starts on Sunday, ending on Saturday, my formula uses the ISBLANK
function, as I don't always have to come in on weekends. However, I have
random #VALUE! errors in the cells that show the time worked. Most of the
cells show a blank if there is no start time for the day, but I currently
have the value error on Monday and Tuesday of the second week. No matter how
many times I copy/paste from a working cell, or manually type in the formula,
this error won't go away. Any ideas as to what I might be missing? Thank
you.

#Value in random cells
 

"Michael" wrote:
my formula uses the ISBLANK
function, as I don't always have to come in on weekends. However, I have
random #VALUE! errors in the cells that show the time worked. Most of the
cells show a blank if there is no start time for the day

Most likely, some cells that "show a blank" actually contain "", for example
resulting from formulas of the form IF(ISBLANK(A1),"",A1+B1).
Change ISBLANK(A1) to A1="". ISBLANK is true only when a cell has no
formula and no constant; that is, it is completely empty. A1="" also
returns true when A1 equals "".


----- original message -----

"Michael" wrote in message
...
I have a formula to calculate the hours I work based upon time in and time
out - time in is deducted from time out. Since my time is based on two
weeks
and starts on Sunday, ending on Saturday, my formula uses the ISBLANK
function, as I don't always have to come in on weekends. However, I have
random #VALUE! errors in the cells that show the time worked. Most of the
cells show a blank if there is no start time for the day, but I currently
have the value error on Monday and Tuesday of the second week. No matter
how
many times I copy/paste from a working cell, or manually type in the
formula,
this error won't go away. Any ideas as to what I might be missing? Thank
you.