Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the time value represented by datetime or expression, based on the system's Region and Language settings.
Syntax
TIMEVALUE(" datetime "| expression [, lcid ])
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| datetime |
Required |
String |
Any string commonly recognized as a date and time or a reference to a cell containing a date and time. |
| expression |
Required |
Varies |
Any expression that yields a date and time. |
| lcid |
Optional |
Number |
The locale identifier to be used in evaluating a nonlocal datetime. The locale identifier is a number described in the system header files. |
Remarks
Any date component in datetime or expression is discarded.
If datetime is missing or cannot be converted to a valid result, this function returns a #VALUE! error.
The TIMEVALUE function also accepts a single number value for expression where the decimal portion of the result represents the fraction of a day since midnight.
Example 1
TIMEVALUE("6:00 AM")
Returns the value representing 6:00 AM.
Example 2
TIMEVALUE("14:30")+4 eh.+30 em.
Returns the value representing 19:00:00.
Example 3
TIMEVALUE("11 AM, July 1, 1997")
Returns the value representing 11:00 AM.
Example 4
TIMEVALUE(0.6337)
Returns the value representing 15:12:32.
Example 5
TIMEVALUE("7:89")
Returns a #VALUE! error.