Export (0) Print
Expand All
Expand Minimize

HOUR Function (VisioShapeSheet)

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

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

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

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.

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.

HOUR("15:45")

Returns 15.

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

Returns 15.

HOUR(0.5)

Returns 12.

HOUR("5/30/1997")

Returns 0.

Show:
© 2014 Microsoft