Difference between revisions of "Documentation/How Tos/Calc: TIMEVALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
|||
Line 2: | Line 2: | ||
== TIMEVALUE == | == 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: === | === Syntax: === | ||
Line 10: | Line 9: | ||
: <tt>'''TIMEVALUE '''</tt> returns the date-time serial number, which may be formatted to read as a time. | : <tt>'''TIMEVALUE '''</tt> returns the date-time serial number, which may be formatted to read as a time. | ||
− | |||
=== Example: === | === Example: === | ||
<tt>'''TIMEVALUE ("16:48:00")'''</tt> | <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>. | : 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: === | === See also: === | ||
Line 24: | Line 21: | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | ||
− | |||
− | |||
− | |||
− |
Revision as of 10:04, 16 January 2008
TIMEVALUE
returns the date-time serial number, from a time given as text.
Syntax:
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.
Example:
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.