Excel Function : TIMEVALUE

Download now!

Excel Function : TIMEVALUE

Category

Date and time

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TIMEVALUE-function-0b615c12-33d8-4431-bf3d-f3eb6d186645

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.