w3resource

Excel MINUTE() function

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.

minute

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



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/excel/excel-minute-function.php