Thursday, April 27, 2017

TIMEVALUE function

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)

No comments:

Post a Comment