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]
