Documentation/How Tos/Calc: TIMEVALUE function
From Apache OpenOffice Wiki
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.