MINUTE()

MINUTE() returns the minutes portion of a specified DateTime as a number.

Use MINUTE() to isolate the minutes portion of a DateTime.

Function Format

MINUTE(D)

MINUTE() returns a numeric value denoting the minutes portion of a DateTime.

If the DateTime is purely a date, then MINUTE() returns a zero value.

Examples

Using a 24-hour clock and a time of 11:12:32 p.m.:

MINUTE(‘23:12:32‘) = 12