Return the minute within the hour from a valid date/time value or supported time string. =MINUTE(TIME(16,45,30)) is expected to return 45. This is different from 16 hours 45 minutes of elapsed time.

Extract minute-of-hour components from Apple Numbers date/time cells with worked scheduling examples. For a reproducible time source, use Numbers’ TIME constructor rather than ambiguous local-language time strings. Preserve original imported values when cleaning data so a formula result doesn’t hide a source problem. The examples below intentionally share a dataset with the companion HOUR, MINUTE, SECOND and TIME tutorials while verifying each function’s separate contract.

=MINUTE(time)

Return: a numerical time component of the value supplied. MINUTE reports the minute component of the supplied time. It does not return all minutes elapsed since midnight, and the 15:00 time formed from 900 input minutes has a minute component of 0.

Official behaviour: The MINUTE reference identifies the date/time-or-string input and illustrates extraction of minute 59 from a timestamp. These examples independently apply that operation to TIME-built values. See the official Apple MINUTE reference (documentation path 15.4, consulted 2026-10-11). The function-specific help does not establish a first-supported app release; do not extrapolate minimum Mac/iOS/iPadOS/web versions.

Create a Numbers table named Times. Set row 1 as its header. Enter A2:C6 as numbers, not timestrings; set D2:D6 to a Date & Time format that shows clock hours, minutes and seconds, after adding formulas. Columns E–G are formula result columns. No source CSV, external download or screenshot is required.

*The D entries describe the expected clock time. Numbers can show an AM/PM display or include a date depending on the Date & Time cell format. The rows use actual numeric inputs; do not paste the displayed D text to substitute for a time value.

In F2 enter =MINUTE(D2) after creating D2 with =TIME(A2,B2,C2), then fill down the F column.

1. Create the Numbers table Times from the shared input table below, keeping A–C as numbers.
2. In D2 enter =TIME(A2,B2,C2); fill through D6 and choose a Date & Time display including seconds.
3. In F2 type =MINUTE(D2) and fill F2:F6.
4. Expected F2:F6: 7, 45, 0, 59, 0. The result is numeric; it need not be shown with two digits.
5. Direct check: =MINUTE(TIME(9,7,5)) is expected to produce 7, whereas the clock display shows 09:07:05.
6. Edge check: =MINUTE(TIME(0,900,0)) is expected 0. Apple’s TIME reference explains why an input containing 900 minutes becomes 15:00.

Place meetings into first/second half-hour buckets

Suppose meeting start times occupy D2:D6. Add this to H2 and fill down:

=IF(MINUTE(D2)<30,"Minute 00–29","Minute 30–59")

Expected H2:H6: Minute 00–29, Minute 30–59, Minute 00–29, Minute 30–59, Minute 00–29. This is useful for categorizing within-hour arrival timing, such as visits beginning during the first versus second half of their starting hour.

Important limitation: this formula doesn’t group records into the same absolute half-hour time slot across hours. A 9:15 and a 10:15 both return the same label, while a 9:15 and 9:45 differ. For real calendar grouping, combine an hour/date key with the minute bucket using a separately validated method.

Quality-check a time import

=MINUTE(D3)=45 is expected TRUE when D3 is built from TIME(16,45,30). Comparing the extracted component against a known control row can help catch an accidentally swapped minute/second input column, but does not independently validate a text-import parser.

• Wrong mental model: MINUTE(TIME(16,45,30)) yields 45, not 1005 total minutes since midnight or a duration of 16h45m.
• Leading zero display: MINUTE(TIME(9,7,5)) returns the number 7, not a guaranteed text value "07". Format a destination cell separately if required for a label.
• Missing or swapped arguments: MINUTE takes one time argument; TIME takes three numeric arguments. Do not type =MINUTE(16,45,30).
• Text import variability: a string such as "09:07" can be parsed according to app/locale assumptions; this guide avoids making exact cross-locale promises. Prefer a true Date & Time cell.
• Time rollover: TIME(0,900,0) has a minute component of zero after normalization; do not expect MINUTE to return 900.
• Blank/header errors: use D2, not the D1 column heading, and verify the source is a valid time value if the formula reports an error.
• Cross-table formula: =MINUTE(Times::D2) addresses table Times from a different table; a bare D2 there would refer to the wrong table.

This tutorial was checked against Apple’s English Formulas and Functions Help 15.4 on 2026-10-11. The 15.4 in a documentation URL describes the help edition. It does not establish a function’s first-supported Numbers release or prove identical execution across macOS, iOS, iPadOS and iCloud.com. Apple documents a Functions Browser in Numbers on Mac, iPhone, iPad and on iCloud.com, but none of those native app editions was used to run these examples. Treat historical releases as unverified unless their own documentation is checked.

Use normal Numbers table references, not Excel worksheet notation: A2 is a same-table cell; Times::D2 is the unambiguous cross-table form when a table named Times is elsewhere on the sheet; Sheet 2::Times::D2 names a sheet and table when required. Apple’s cell-reference help documents the double-colon form. When editing, select the desired cell to have Numbers construct the reference rather than typing a guessed table prefix.

The English examples separate function arguments with commas. Apple’s functions overview instructs users whose regional settings use a comma decimal separator to use semicolons between function arguments when typing by hand. For example, change =TIME(9,7,5) to =TIME(9;7;5), but do not change punctuation inside quoted text. Displayed date/time order and AM/PM appearance are formatting/localization issues, not a different formula signature. Avoid relying on interpretation of ambiguous imported time strings.

The names of these common date/time component functions occur in other spreadsheet products, but matching names do not certify identical handling of imported text, time zones, date serials, errors, or special inputs. The examples here are grounded in Apple’s documented Numbers syntax. Copying Excel Sheet1!D2 references or a Google Sheets tab-qualified formula into Numbers is not a direct substitute for Numbers table references (Times::D2). A number representing clock time is not the same as a duration; elapsed working time across midnight needs a separately designed calculation, not merely a component extractor. Cross-application execution and conversion were not tested.

• COUNTIFS: count records meeting multiple conditions
• SUMIFS: total records meeting multiple conditions

For related time functions, these direct Apple documentation links provide the primary syntax references: TIME, HOUR, MINUTE, SECOND.

• Apple Numbers — function documentation
• cell-reference help
• functions overview
• TIME
• HOUR
• SECOND
• Apple: Formulas and Functions Help

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.