Re: [office-formula] 6.9.16 TIME

[Eike Rathke <erack@sun.com>]

Hi Eric,

On Monday, 2009-03-09 17:13:08 +0000, Eric Patterson wrote:

> The text in Section 6.9.16 does not indicate how to interpret negative
> values for Hours, Minutes and Seconds.  There are a number of test
> cases that show the use of negative value for parameters, but this
> doesn't carry through to the text.

Lacks definition. Something like

"Negative arguments' values are substracted from the result."

maybe? Better wording, anyone?

> Also, the result of one of the test cases appears to be incorrect.
> The last test case (=TIME(11;-125;-144)*60*60*24) indicates that
> a value of -31956 should be returned.  I believe the value should be
> +31956.

True, +11 hours -125 minutes -144 seconds still is a positive value.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature