It converts a text value to the time format that Excel recognizes. This is a decimal number ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
The syntax of the function is the following:
TIMEVALUE(time_text)
time_text: The text that we want to convert to time
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the TIMEVALUE function:
Display, in the cell I2, the time of cell A2, as number, with the use of the proper formula,