MINUTE Function

Returns the minutes from a time.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A number from 0 to 59

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

MINUTE returns the minute part of a time, from 0 to 59.

Pair it with HOUR to break a time or a duration into parts.

Syntax

=MINUTE(serial_number) Explain

Arguments

ArgumentRequired?What it does
serial_numberYesA time, a date with a time, or time text.

Examples

Example 1 — Minutes past the hour

Pull the minutes out of each time.

B2fx=MINUTE(A2)
AB
1TimeMinute
29:30 AM30
36:45 PM45
412:05 AM5
=MINUTE(A2) Explain

Example 2 — Meeting length in minutes

Turn the gap between two times into whole minutes.

C2fx=HOUR(B2-A2)*60+MINUTE(B2-A2)
ABC
1StartEndMinutes
29:15 AM11:50 AM155
=HOUR(B2-A2)*60+MINUTE(B2-A2) Explain
=ROUND((B2-A2)*1440, 0) gives the same answer — there are 1,440 minutes in a day.

Common mistakes

  • MINUTE of a duration over an hour. MINUTE only returns the leftover minutes (2:35 gives 35). Multiply by 1440 for total minutes.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.