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: [office-formula] 6.9.16 TIME


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.

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.

-Eric


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