<< Click to Display Table of Contents >> TIMEVALUE (convert text into time) |
Syntax:
TIMEVALUE(Text)
Description:
Converts a text string representing a date to a serial time value.
Note:
This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including PlanMaker) automatically convert values into date/time values, where necessary.
Example:
TIMEVALUE("10:30:00 am") returns 0.4375.
If you now format this using the options of the ribbon tab Home | group Number in one of the date/time formats (for example h:mm), the cell will display the date behind this value: 10:30.
See also: