Exceljet

Quick, clean, and to the point

Excel MINUTE Function

Excel MINUTE function
Summary 

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.

Purpose 
Get minute as a number (0-59) from time
Return value 
Number between 0 and 59.
Syntax 
=MINUTE (serial_number)
Arguments 
  • serial_number - A valid date or time.
Usage notes 

The MINUTE function extracts the minute from a time as a number between 0-59. For example:

=MINUTE("9:45 AM") // returns 45
=MINUTE("3:10 PM") // returns 10

You can use the MINUTE function to extract the minute into a cell, or feed the result into another function like the TIME function. For example, with the time 5:45 PM in cell A1, you can create a new time that includes 45 minutes like this:

=TIME(7,MINUTE(A1),0) // returns 7:45 PM

Times can be supplied as text (e.g. "7:45 PM") or as decimal numbers (e.g. 0.5, which equals 12:00 PM). In general, it's best to use the TIME function to create time values, because it reduces errors.

Note: Excel stores dates and times as serial numbers. For example, the date Jan 1, 2000 12:00 PM is equal to the serial number 32526.5 in Excel. To check that Excel is correctly recognizing a date or time, you can temporarily format the date as a number.

Notes

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.