Excel Function : TIMEVALUE

Download now!

Excel Function : TIMEVALUE


Date and time


Converts a time in the form of text to a serial number

Microsoft Excel Reference Page


Syntax and Description of the TIMEVALUE Excel Function

syntax. =TIMEVALUE(1/1/2018 12:00:00 AM) TIMEVALUE formula syntax

About TIMEVALUE Excel Function

The TIMEVALUE function returns the time represented by a text string. The time is returned as a serial number. TIMEVALUE("18:45:15") Returns 0.791666666666667, the time represented by the text string.