HOUR Function (VisioShapeSheet)

發行項
09/15/2015

Returns an integer, 0 to 23, representing the hour of the day of datetime or expression.

Syntax

HOUR("datetime"|expression[,lcid])

Parameters

Name	Required/Optional	Data Type	Description
datetime	Required	String	A string commonly recognized as a date and time or a reference to a cell containing a date and time.
expression	Required	Varies	An expression that yields a date and time.
lcid	Optional	Number	A locale identifier to be used in evaluating a nonlocal datetime. The locale identifier is a number described in the system header files.

Remarks

The date component in datetime and expression is discarded.

No rounding is done. If the datetime is missing or cannot be converted to a valid result, the function returns an error.

The returned value is formatted according to the time style set by the system's current Regional Settings.

The HOUR 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

HOUR("15:45")

Returns 15.

Example 2

HOUR("May 30, 1997 3:45:24 PM")

Returns 15.

Example 3

HOUR(0.5)

Returns 12.

Example 4

HOUR("5/30/1997")

Returns 0.

共用方式為