MINUTE 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

Returns an integer from 0 to 59 that represents the minutes component of datetime or expression.

MINUTE("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

String

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.

Return Value

Integer

The date component in datetime and expression is discarded.

No rounding is done. If 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 MINUTE function also accepts a single number value for expression where the decimal portion represents the fraction of a day since midnight.

MINUTE("7/7/1999 13:45:24")

Returns 45.

MINUTE(TIMEVALUE("Jan. 25, 1999 12:07:45")+6 em.)

Returns 13.

MINUTE(0.575)

Returns 48.

Show: