Chema, Have you looked up the error code? If not, look at: http://documentation.openoffice.org/manuals/oooauthors2/0315CG-CalcErrorCodes.pdf. What does "1600:00:00" represent?
Witstert -----Original Message----- From: Chema [mailto:[email protected]] Sent: 14 January 2009 21:17 To: [email protected] Subject: Re: [users] Re: problems with time operations on OOcalc 3 NoOp escribi: > On 01/14/2009 07:39 AM, Chema wrote: > [snip] > > >> Hi again. >> I receive a message that say me that with version 2 my formula works but >> not works on version 3... >> Is this a bug? >> Regards >> Chema >> > > >From F1 (Help): > > TIME > TIME returns the current time value from values for hours, minutes and > seconds. This function can be used to convert a time based on these > three elements to a decimal time value. > Syntax > TIME(Hour; Minute; Second) > Use an integer to set the Hour. > Use an integer to set the Minute. > Use an integer to set the Second. > Examples > =TIME(0;0;0) returns 00:00:00 > =TIME(4;20;4) returns 04:20:04 > > Note the semicolons in the function argument. > > TIMEVALUE > TIMEVALUE returns the internal time number from a text enclosed by > quotes and which may show a possible time entry format. > The internal number indicated as a decimal is the result of the date > system used under OpenOffice.org to calculate date entries. > Syntax > TIMEVALUE("Text") > Text is a valid time expression and must be entered in quotation marks. > Examples > =TIMEVALUE("4PM") returns 0.67. When formatting in time format HH:MM:SS, > you then get 16:00:00. > =TIMEVALUE("24:00") returns 1. If you use the HH:MM:SS time format, the > value is 00:00:00. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > I'm sorry for my ignorance,but I don't understand what's means your comment about my mail. 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... Regards Chema --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
