### TIMEVALUE(time_text)

Returns the time as a decimal given a time in text format.

 time_text The text string that represents the time.

#### Remarks

 * In Excel times are represented as decimals.* If "time_text" contains any date information, it is ignored.* If "time_text" is not a valid time, then #VALUE! is returned.* The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).* Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).* The time format can be any of those on the "Format Cells" dialog box.* You can use the DAY function to return the day as an integer given a date serial number.* You can use the DATEVALUE function to return the date serial number for a date in text format.* You can use the MINUTE function to return the minute as an integer given a date serial number.* You can use the SECOND function to return the number of seconds as an integer given a date serial number.* You can use the TEXT function to convert a date serial number into a formatted text string.* For the Microsoft documentation refer to support.office.com

 A 1 =TIMEVALUE("12:00 PM") = 12:05 AM 2 =TIMEVALUE("12:00 PM") = 0.500 3 =TIMEVALUE("6:00 PM") = 6:00 PM 4 =TIMEVALUE("6:00 PM") = 0.750 5 =TIMEVALUE("2:24 AM") = 0.100 6 =TIMEVALUE("22-Aug-1955 6:35 AM") = 0.274 7 =TIMEVALUE("01/07/1977 12:00:00") = 0.500 8 =TIMEVALUE(TEXT(0.12345,"hh:mm:ss")) = 0.123 9 =TIMEVALUE(TEXT(0.12345,"dd-mm-yy hh:mm:ss")) = #VALUE! 10 =TIMEVALUE(TEXT(0.12345,"0.000")) = #VALUE!