[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. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]