MINUTE in Excel: Extract Minute Components and Check Time Bands

• Introduced: first introduction version is not established by the official history reviewed; the current product list is not a launch record.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official MINUTE reference. Documentation and independently modeled examples; no native Excel execution or broader platform certification.

=MINUTE(serial_number)

The required input supplies a time as a numeric serial, recognized text or another formula result. Microsoft describes the output as an integer minute field. This guide uses numeric TIME constructions for its primary controls and formats the extracted answer as General or Number.

A time serial is measured in days: noon is 0.5. MINUTE selects the minute field within the current hour, rather than converting the entire serial into minutes.

=MINUTE(TIME(2,45,30))
=MINUTE(TIME(2,59,59))
=MINUTE(TIME(3,0,0))
=MINUTE(TIME(0,0,0))

Expected results are 45, 59, 0 and 0. Advancing from 02:59:59 to 03:00:00 resets the component to zero. The minute field alone cannot show which hour the time belongs to.

For another independent check, =MINUTE(0.5) gives 0, because the numeric fraction 0.5 represents exactly noon, with zero minutes past the hour.

=MINUTE(DATE(2026,10,14)+TIME(8,15,0))
=MINUTE(DATE(2026,10,15)+TIME(18,15,0))

Both expected outputs are 15, although the timestamps differ in both day and hour. Grouping records by MINUTE alone combines every occurrence of the same minute field across all those hours and dates.

That can be useful when investigating a repeating within-hour schedule, but it is unsuitable as a unique chronological key. Retain the original timestamps in the source table.

Enter 08:00, 08:14, 08:15, 08:29, 08:30, 08:44, 08:45 and 08:59 in A2:A9 using TIME formulas. In B2 enter and fill down:

=INT(MINUTE(A2)/15)

Expected bucket numbers are 0, 0, 1, 1, 2, 2, 3 and 3. They divide each hour into minute ranges 0–14, 15–29, 30–44 and 45–59. These bucket numbers do not include the hour itself.

The examples use whole-minute inputs, so they do not establish an every-subsecond boundary guarantee. State whether a reporting interval includes or excludes its endpoint before applying it to real timestamps.

For A2 holding the numeric time 08:37:20:

=TIME(HOUR(A2),15*INT(MINUTE(A2)/15),0)

Expected clock result: 08:30:00. HOUR supplies 8, MINUTE supplies 37, integer division selects bucket 2, and 15*2 supplies minute 30. The second argument is not the total number of elapsed minutes since midnight.

The formula returns a time without a date. For a positive modern complete timestamp, add its INT(A2) date portion if a complete dated bucket is required. If the report instead needs rounding to the nearest quarter hour, that is a different rule from selecting the containing interval.

For a duration of one hour, forty-five minutes and thirty seconds:

=MINUTE(TIME(1,45,30))
=TIME(1,45,30)*24*60

Expected results are 45 and 105.5. The first is the minute component; the second converts the full time fraction into minutes. A 26.5-hour duration similarly has MINUTE component 30 but total duration 1590 minutes.

If start and end include their complete dates, (end-start)*1440 expresses their numeric difference in minutes. Do not use MINUTE(end-start) when the interval can exceed one hour: it loses the completed hours and days.

Times 08:15 and 19:15 both return minute 15, but their same-day difference is 11 hours, or 660 minutes. Comparing only their minute components gives equality and answers a narrower question.

A schedule check such as =MOD(MINUTE(A2),15)=0 is TRUE for minute fields 0, 15, 30 and 45. It still accepts 08:15:30 because the minute field is 15; require a seconds condition too if the rule means an exact whole-second quarter-hour mark.

HOUR and SECOND provide the other time fields. TIMEVALUE documents parsing recognized time text. None of those functions makes an unverified time-zone conversion automatic.

The sparse MINUTE reference does not provide a complete native error or coercion matrix for blanks, malformed text, negative serials or every fractional-second boundary. Those cases remain unverified rather than borrowed from another program.

• Microsoft MINUTE reference.
• Editorial testing standards.

Expected results are independent calendar/arithmetic models or explicitly documented rules, not captured native output. Examples use English function names and comma separators. Input dates and schedules are fictional.