Article updated on June 17, 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:

=TIMEVALUE("1:48 AM")

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.