Excel MINUTE() function

Last update on August 19 2022 21:50:55 (UTC/GMT +8 hours)

MINUTE() function

This function is used to return the minutes of a time value. The minute is given as an integer, ranging from 0 to 59.

Version : Excel 2013

Syntax

MINUTE(serial_number)

Parameters

Name	Description	Data Type	Required/ Optional
Serial_number	The time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, "7:13 AM"), as decimal numbers (for example, 0.69425), or as results of other formulas or functions (for example, TIMEVALUE("7:13 AM")).	Integer	Required

Remarks:

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5, since it is half of a day).

Example - 1:

The example below returns the minute portion of the time in A2.

Previous: Excle ISOWEEKNUM() function
Next: Excel MONTH() function