TIMEVALUE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
