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.
Previous: Excle ISOWEEKNUM() function
Next:
Excel MONTH() function
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework