TIMEVALUE Function (VisioShapeSheet)

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Example 4
Example 5

Returns the time value represented by datetime or expression, based on the system's Region and Language settings.

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.

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.

TIMEVALUE("6:00 AM")

Returns the value representing 6:00 AM.

TIMEVALUE("14:30")+4 eh.+30 em.

Returns the value representing 19:00:00.

TIMEVALUE("11 AM, July 1, 1997")

Returns the value representing 11:00 AM.

TIMEVALUE(0.6337)

Returns the value representing 15:12:32.

TIMEVALUE("7:89")

Returns a #VALUE! error.

Show: