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: