On 01/14/2009 07:39 AM, Chema wrote:
I receive a message that say me that with version 2 my formula works
but not works on version 3...
Is this a bug?
At 22:17 14/01/2009 +0100, Chema wrote:
I talk about in version 2 OOcalc the formula = (1600:00:00 - A1) (A1
is other cell with value 160:00:00) works and I can see a result and
in version 3 OOcalc the same formula has result Err:502...
Whatever may or may not have worked in version 2, in version 3 you
cannot (apparently) include a time expressed as 1600:00:00 in a
formula. You need to use either TIME(1600;0;0) or else
TIMEVALUE("1600:00:00") - whichever you prefer. Another way would be
to put the constant value in a cell and then refer to that cell in the formula.
Is it a bug? No: it's a feature!
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
