Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

TIMEVALUE

Description: Returns the serial number of a time that has been entered as a text string, where 12:00:00 AM is 0 (zero) and 11:59:59 P.M. is 0.9999884259. Note that the Time_text must be in quotation marks.

Syntax: TIMEVALUE(Time_text)

• Time_text is a text string that represents a time in any one of the software’s time formats. For example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.

Remarks:

• Date information in Time_text is ignored.

• Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).

Example:

• TIMEVALUE("2:24 AM") = 0.1

• TIMEVALUE("22-Aug-1955 6:35 AM") = 0.274305556