Related Topics: | ||
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
© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.