Skip to content
Excel

MINUTE function in Excel

Converts a serial number to a minute

=MINUTE(serial_number)

MINUTE syntax and parameters

One argument, one required.

  • serial_numberanyRequired

    The time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

MINUTE examples

Formulas you'll actually reuse.

  1. The minute part of a 17:15 clock-out time:

    =MINUTE(C2)

    Result15

  2. The leftover minutes of a shift — 08:30 to 17:15 is 8 h 45 min:

    =MINUTE(C2 - B2)

    Result45

MINUTE in Google Sheets

Same name — your formula ports as-is.

Try MINUTE in the playground

Edit the example — nothing to install.

Preloaded with the MINUTE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.