On 01/14/2009 01:17 PM, Chema wrote: > 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: users-unsubscr...@openoffice.org >> For additional commands, e-mail: users-h...@openoffice.org >> >> >> > 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
It means that that OOo2 Calc had bugs and OOo3 corrects them. The Err:502 is telling you that you entered the formula/format incorrectly. Please read the F1/Help section on times, formats: Time Formats To display hours, minutes and seconds use the following number format [snipped] To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter hh:mm:ss.00 to display the time as "01:02:03.45". If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS So change your formula to ="1650:0:0" - C1 and it will work. Or as Brian suggested, =TIME(1650;0;0) - C1 In OOo3 if I have A1= 1650:00:00 A2= 1650:00:00 C1= =SUM(A1:A5) the result in C1 is: 12:00:00 Now in C4 I put: ="1650:0:0" - C1 the result in C4 is 06:00:00 However, in the above you still get inaccurate results as the format is [HH]:MM:SS. So 1650 get rounded to 18:00:00, etc. Change to: A1= 16:50:00 A2= 16:50:00 C1= =SUM(A1:A5) the result in C1 is: 09:40:00 Now in C4 I put: ="16:50:00" - C1 the result in C4 is 07:10:00 The results will be exactly the same in both OOo2 and OOo3 if you follow the format. Put the above in OOo2 and you will see. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org