OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] 6.9.16 TIME

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.


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

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]