Using Excel's TIMEVALUE Function
SummaryThe TIMEVALUE function in Excel will return the decimal number of a time as a string of text. The decimal value will range from 0 (zero) representing 12:00:00 AM to 0.99988426 representing 11:59:59 PM. The decimal representation of a time value is useful when working with other functions, formulas, or pivot tables since they can be directly manipulated.
Time_text is a required field that is a text string representing a time. The value can be entered in any Excel time format. For example, “5:00 PM” and “17:00” are the same time.
Usage NotesDate Elements
You can enter date arguments in the TIMEVALUE function and the function will still execute. However, the date elements will be ignored. If you require a function that converts a text date to an Excel serial number, the DATEVALUE function can be used.