## How to use the TIMEVALUE function

*Article updated on February 26, 2018*

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 formatted as time. 0 (zero) is 12:00:00 AM and 0.99988426 is 11:59:59 P.M.

Formula in cell B3:

### Excel Function Syntax

TIMEVALUE(*time_text*)

### Arguments

time_text |
Required. A text string within quotation marks that represent time, for example "03:23 PM" or "22:21". |

### Comments

The TIMEVALUE function ignores dates , example "22-Aug-2019 6:35 PM" returns 0.774305556.

### Articles with the 'TIMEVALUE' Function

The following 2 articles have formulas that contain the TIMEVALUE function.

### Functions in 'Date and Time'

The TIMEVALUE function function is one of many functions in the 'Date and Time' category.