The TIMEVALUE function returns the decimal value of the given time from the given text string. Note: The returned decimal value ranges from 0 (zero) to 0.99999999, representing from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Formula:
=TIMEVALUE(Time Text) whereas “Time text” is the text string that represents time.
Video Tutorial:
Let us find the time from the given values, using TIME function, with the help of the below video.