Syntax:
TIMEVALUE(Text)
Description:
This converts a text string representing a date into 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 times specified as text into date/time values if 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 time behind this value: 10:30.
See also: