TIMEVALUE Function Explained

The TIMEVALUE Function in Microsoft Excel converts a text representation of a time into a serial number that Excel recognizes as a time. It takes a single argument, which is a text string that represents a time in one of the recognized formats. The function returns the serial number that corresponds to the time represented by the text string.

TIMEVALUE Function Syntax

TIMEVALUE(time_text)

  • time_text: A text string that represents a time in any one of the Microsoft Excel time formats (including the hour, minute, and second components).