Minute Function

Named Arguments

Yes

Syntax

Minute(time)

time

Use: Required

Data Type: Date/Time

Any valid date/time expression, or an expression that can be evaluated as a date/time expression.

Description

Returns an integer between and 59 representing the minute of the hour from a given date/time expression.

Rules at a Glance

If time is Null, the Minute function returns Null.

Programming Tips and Gotchas

If time isn't a valid date/time expression, the function generates runtime error 13, "Type mismatch." To prevent this, use the IsDate function to check the argument before calling the Minute function.

See Also

Hour Function, Second Function

Get VB & VBA in a Nutshell: The Language now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.