Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
TIMEVALUE Function / Formula in Microsoft Excel 2007 | Video Tutorial

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