The MINUTE function returns an integer representing the minutes component of a supplied Excel time.

Syntax

=MINUTE(serial_number)

Arguments

Argument Description
serial_number A valid time from which you want to extract the minutes component
  • Times can be supplied as text (e.g. “7:45 PM”) or as decimal numbers (e.g. 0.5, which equals 12:00 PM).
  • If the serial_number argument contains a date and time, the MINUTE function ignores the date part of the argument.

Examples

  A B C D
1 Time Formula Result Notes
2 12:10:30 PM =MINUTE(A2) 10 Basic usage – only minutes are returned
3 12:10 PM =MINUTE(A3) 10 Hours are ignored
4 7/20/2015 7:30:24 PM =MINUTE(A4) 30 Date component is ignored
5 20-Jul-2015 =MINUTE(A5) 0 Date contains no time component
6 7:30:24 PM =MINUTE(A6) 30 Valid time entered as text

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied serial_number is not a valid time