Excel TIMEVALUE function

Function              TIMEVALUE

Description        Excel TIMEVALUE function returns the serial number of the date represented by time_text. Use TIMEVALUE to convert a time represented by text to a serial number.

Syntax  TIMEVALUE(time_text)

time_text: A string representation of a time

Example:

= TIMEVALUE (“10:34:12”)

= 0.440416666666667