Wauvel

Excel like a finance pro.

← The library

Date function

MINUTE

Returns the minute from a time.

OccasionalDifficulty 950 · CapableUsage rank #176 of 520
Practice · 2 questions →

When to use it

The minute, 0 to 59, from a time.

The shape of it

Syntax
=MINUTE(serial_number)

Worked examples

  • Minute of a time

    =MINUTE(TIME(18,45,30)) → 45

    Forty-five past.

  • Minutes part of a gap

    =MINUTE(B1-A1) → 15

    Minutes part of the gap between 9:30 and 11:45.

  • Minutes since midnight

    =HOUR(A1)*60+MINUTE(A1) → 1125

    Minutes since midnight for 6:45 PM.

Worth knowing

  • Total minutes of a duration: =(B1-A1)*1440.
  • Round to the nearest 15: MROUND(A1,"0:15").
  • Works on date-times.

Where it goes wrong

  • Returns only the minute component, not total minutes.
  • Text input returns #VALUE!.

Related

TODAYDATEMONTHYEARNOWDAY

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.