Difference between revisions of "Documentation/How Tos/Calc: TIMEVALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
|||
Line 17: | Line 17: | ||
'''[[Documentation/How_Tos/Calc: TIME function|TIME]]''', | '''[[Documentation/How_Tos/Calc: TIME function|TIME]]''', | ||
'''[[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]]''' | '''[[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]]''' | ||
+ | |||
+ | '''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | ||
− | '''[[Documentation/How_Tos/Calc: | + | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], |
+ | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] |
Revision as of 07:11, 12 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