Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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,

Share this Post