TIMEVALUE Function

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.

Learn MS Excel


Ask Questions

Ask Question