MINUTE

Gets the minute component of the specified date.

Syntax

=MINUTE(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

=MINUTE(DATE(2020, 2, 3, 4, 5))5
Gets the minute component 5 from the specified date Feb 3, 2020 4:05 AM

=MINUTE(DATE(2020, 4, 5, 6, 7))7
Gets the minute component 7 from the specified date Apr 5, 2020 6:07 AM