This function returns the TimeSpan object of the time represented by a text string.
TIMEVALUE(time_string)
Specify a time as a text string.
Use this function to convert a time represented by text to a TimeSpan object in standard format. The time span is an amount of days, hours, minutes, and seconds.
Accepts string data. Returns a TimeSpan object.
TIMEVALUE(B18)
TIMEVALUE(R18C2)
TIMEVALUE("5:29") gives the result 05:29
TIMEVALUE("5:29 PM") gives the result 17:29
TIMEVALUE("17:29") gives the result 17:29