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.