Converts a text string representing a time into a time value.
TIMEVALUE(time_text)
time_text
TIMEVALUE("3:30:00")
Result: 0.145833333
0.145833333
TIMEVALUE("17:30:00")
Result: 0.729166667
0.729166667