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]
