Excel minute function

The Excel MINUTE function extracts the minute component of a time as a number between 0-59. For example, with a time of 9:45 AM, minute will return 45. You can use the MINUTE function to extract the minute into a cell, or feed the result into another function like the TIME function.

Syntax: =MINUTE (serial_number)

The Minute function syntax has the following arguments:

Serial_number (required argument) – The time that contains the minute we want to find.

The argument can be entered as:

  1. A decimal (serial number) representation of an Excel time
  2. A text representation of a time
  3. A reference to a cell containing a time
  4. A time value returned from another Excel function or formula

Example: Let’s look at some Excel MINUTE function examples and explore how to use the MINUTE function as a worksheet function in Microsoft Excel:

MINUTE Function 1 - Excel minute function

Syntax: =MINUTE(A2) 

Result:

MINUTE Function - Excel minute function

=MINUTE(A3)
Result: 50

=MINUTE(A4)
Result: 51

=MINUTE(A5)
Result: 41

READ:  Average excel formula

Add a Comment

Your email address will not be published. Required fields are marked *