How to Use the TIMEVALUE Function in Excel

This guide explains how to use TIMEVALUE Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the decimal number of time indicated by a text string. The decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).

Syntax: TIMEVALUE (time_text)

Where: time_text is the time value expressed in the text to be expressed in decimal.

Attention:

- Date information in time_text is ignored.

- The time value is part of the date value and is expressed as a decimal.

For example:

Find the decimal value corresponding to the time value below:

- In the cell to calculate, enter the formula: = TIMEVALUE ("2:35:59").

- Press Enter -> corresponding values are:

- Similarly, enter the formula for the remaining values:

- Where two values with the same time but different dates -> the function returns the same result -> the date value in the TIMEVALUE function is ignored:

- In case you enter the formula as the reference value to cell F11:

- Press Enter -> function returns the #VALUE! Error value So you should enter the time_text value as a text string when working with TIMEVALUE:

Above are instructions and some specific examples when using TIMEVALUE function in Excel.

Good luck!