Error message #VALUE!
You've probably got text in some of the fields, rather than real times.
Look out for spaces, non-breaking spaces [CHAR(160)], and other non-printing
characters. Changing cell format has no effect if the contents are text.
--
David Biddulph
"swsw" wrote in message
...
Regarding Excel 2003.
Why does the error message #VALUE! (#VERDI! in norwegian) occur when
calculating time?
I'm trying to subtract one field from another containing time values (e.g.
11:30:12-11:23:34). In some fields I get the right answer and in some
fields
I get the error message #VERDI!, even though the format of the fileds is
the
same. I have used the function "copy format" to be sure they have the same
format.
|