Difference between revisions of "Documentation/How Tos/Calc: TIMEVALUE function"

Revision as of 10:04, 16 January 2008

returns the date-time serial number, from a time given as text.

TIMEVALUE (timetext)

timetext is a time, expressed as text.

TIMEVALUE returns the date-time serial number, which may be formatted to read as a time.

TIMEVALUE ("16:48:00")

returns 0.7, the date-time serial number for 16:48:00. This may be formatted to read, for example, 4:48 PM.

@@ Line 2: / Line 2: @@
 == TIMEVALUE ==
-returns the date-time serial number, from a time as text.
+returns the date-time serial number, from a time given as text.
 === Syntax: ===
@@ Line 10: / Line 9: @@
 : <tt>'''TIMEVALUE '''</tt> returns the date-time serial number, which may be formatted to read as a time.
 === Example: ===
 <tt>'''TIMEVALUE ("16:48:00")'''</tt>
 : returns <tt>'''0.7'''</tt>, the date-time serial number for 16:48:00. This may be formatted to read, for example, <tt>'''4:48 PM'''</tt>.
 === See also: ===
@@ Line 24: / Line 21: @@
 '''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
-=== Issues: ===
-The forthcoming ODFF standard requires <tt>'''TIMEVALUE'''</tt> to return the date-time serial number as a time, so Calc should automatically format the result as a time. However currently Calc seems to return the date-time serial number as a number, requiring the user to format the result manually. See [http://www.openoffice.org/issues/show_bug.cgi?id=84903 Issue 84903]