The TIMEVALUE function is meant to parse a time that appears as atext valueinto a valid Excel time.
The TIMEVALUE function takes just one argument, calledtime_text.
Iftime_textis a cell address, the value in the cell must be text.
TIMEVALUE ignores dates if present in a text string.
TIMEVALUE will return a decimal number between 0 and 0.99988426, representing 12:00:00 AM to 11:59:59 PM.
Alternative formula
Notice that the TIMEVALUE formula in C15 fails with a #VALUE!
error, because cell B15 already contains a valid time.
This is a limitation of the TIMEVALUE function.
a number, date, or time format) into a numeric value.
Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
This function can be used to convert locale-specific values into locale-independent values.
