MINUTE Function in Excel: Minute From a Time

⏱ 1 min readUpdated 28 September 2026

DateLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

MINUTE returns 0–59 from a time.

Syntax

=MINUTE(serial_number)
Argument What it means
serial_number Time.

Examples

Example 1

=IF(MINUTE(B2)>10, "Late", "On time")

Flag logins more than 10 minutes past the hour.

HOUR · SECOND

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZCHOOSECOLS Function in Excel: Pick Specific ColumnsExcel Functions A–ZNPER Function in Excel: How Many Payments Until Paid OffExcel Functions A–ZPERCENTRANK.EXC Function in Excel: Percentile Position, Excluding Ends
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong