Adding or combining time problem.
Hi!
Why are you using the TEXT function?
This is one of those "quirky" things where I can't explain why it works the
way it does, I just know that it works the way it does!
The minus sign in a negative (TEXT) value can't be coerced into a numeric
negative so the value remains a TEXT value. When both values are positive
the act of adding them together:
value1 + value2
coerces them into numeric numbers. If you tried using =SUM(value1,value2),
that would return 0 since both values are TEXT and SUM ignores text.
If you try to coerce -value1 using the unary operator it still errors
because -value1 is a TEXT value.
So, why are you using the TEXT function? Why not just: cell_ref-"37:30"
Then =F23+F50 will work.
Biff
"purtech" wrote in message
...
I am trying to simply add times h:mm format.
=TEXT(F22-"37:30","h:mm")
=TEXT(F49-"37:30","h:mm")
These can and do give negative results because I am using the 1904 date
system.
But, if I try to sum the result of these two if any have a negative result
I
get an error. I am using the below for the sum:
=F23+F50 all h:mm
So how do I add values when one is negative? Or is there another way?
Thanks!
|