TIMEVALUE Function
Returns the time value represented by datetime or expression, based on the system settings in the Regional and Language Options item (Control Panel).
Syntax
TIMEVALUE("datetime"|expression[,lcid])
Remarks
Any date component in datetime or expression is discarded.
If datetime is missing or cannot be converted to a valid result, this function returns a #VALUE! error.
The TIMEVALUE function also accepts a single number value for expression where the decimal portion of the result represents the fraction of a day since midnight.
Example 1
TIMEVALUE("6:00 AM")
Returns the value representing 6:00 AM.
Example 2
TIMEVALUE("14:30")+4 eh.+30 em.
Returns the value representing 19:00:00.
Example 3
TIMEVALUE("11 AM, July 1, 1997")
Returns the value representing 11:00 AM.
Example 4
TIMEVALUE(0.6337)
Returns the value representing 15:12:32.
Example 5
TIMEVALUE("7:89")
Returns a #VALUE! error.