Difference between revisions of "Documentation/How Tos/Calc: TIMEVALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
m |
||
Line 5: | Line 5: | ||
=== Syntax: === | === Syntax: === | ||
− | <tt>'''TIMEVALUE (timetext)'''</tt> | + | <tt>'''TIMEVALUE(timetext)'''</tt> |
: <tt>'''timetext'''</tt> is a time, expressed as text. | : <tt>'''timetext'''</tt> is a time, expressed as text. | ||
Line 11: | Line 11: | ||
=== 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>. | ||
Revision as of 08:24, 14 September 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.
See also:
Functions listed alphabetically, Functions listed by category