[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

TIMEVALUE

Syntax:

TIMEVALUE ( date-time-string )

Description: Computes the serial value of the date and/or time represented by the string date-time-string.

Arguments:

Name

Type

Description

date-time-string

text

The date and/or time whose serial value is to be computed. date-time-string can have any valid date and/or time format. Any date information in date-time-string shall be ignored.

 

Return Type and Value: number – The serial value of the date and/or time represented by the string date-time-string.

However, if date-time-string is ill-formed, #VALUE! is returned.

[Example: The following serial values are displayed with 16 decimal places.

TIMEVALUE("10:02:34 ") results in 0.4184490740740740
TIMEVALUE("01-Feb-2006 10:15:29 AM") results in 0.4274189814823330
TIMEVALUE("22:02") results in 0.9180555555555560

end example]