TIMEVALUE function

Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

Syntax

TIMEVALUE(time_text)

Time_text     is a text string that represents a time in any one of the spreadsheet time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.

Remark

Date information in time_text is ignored.

Examples

Formula

Description (Result)

=TIMEVALUE("2:24 AM")

Decimal part of a day, for the time (0.1)

=TIMEVALUE("22-Aug-2008 6:35 AM")

Decimal part of a day, for the time (0.274305556)

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×