MINUTE function

The MINUTE function in Excel is used to extract the minute from a given time value. It returns an integer between 0 and 59, representing the minute portion of the given time.

Syntax

MINUTE(serial_number)

Parameters

• serial_number: The time value or date-time value from which you want to extract the minute. This can be a time in a cell, a reference to a cell containing a time, or a time value expressed in the format "hh:mm:ss".

How It Works

• The MINUTE function works with Excel’s internal time representation, where time is stored as a decimal number. The integer part represents the date, and the decimal part represents the time.
• The MINUTE function extracts just the minute from this time value.

Examples

1. Extracting the Minute from a Time: If you have the time 12:45:30 in cell A1, and you want to extract the minute, use:

   =MINUTE(A1)
   

   Result: 45 (since the minute in the time 12:45:30 is 45).

2. Using a Time in a Formula: If you want to extract the minute from the time 15:30 (3:30 PM):

   =MINUTE("15:30")
   

   Result: 30 (since the minute is 30 in the time 15:30).

3. Using the NOW() Function: To extract the minute from the current time:

   =MINUTE(NOW())
   

   This will return the current minute of the system time.

4. Using a Date-Time Value: If cell A1 contains a date-time value like 2025-05-01 18:45:00, and you want to extract the minute:

   =MINUTE(A1)
   

   Result: 45 (since the time is 18:45, the minute is 45).

Common Use Cases

• Time-based Calculations: The MINUTE function is commonly used when you need to isolate or work with the minute portion of a time or date-time value.
• Timers or Clock Calculations: You can use this function to calculate elapsed minutes or track minute-based events, such as measuring durations or event triggers based on minutes.
• Conditional Logic: You can use the MINUTE function in IF statements or other logical formulas to trigger actions based on specific minute values.

Important Notes

• The MINUTE function will always return a value between 0 and 59, corresponding to the minute portion of the time. If the value is outside this range (e.g., if the time is represented incorrectly), Excel will return an error.
• MINUTE does not consider any other time components, such as hours or seconds, so it will only extract the minute from a given time value.

Error Handling

If the serial_number provided is not a valid time or date-time value, the MINUTE function will return a #VALUE! error. You can handle this error using IFERROR:

=IFERROR(MINUTE(A1), "Invalid Time")

This will return “Invalid Time” if the value in cell A1 is not a valid time.

Summary

The MINUTE function in Excel is a straightforward and useful tool for extracting the minute portion of a time or date-time value. It helps in time-based calculations, conditional logic, and other time-related tasks. The function works in conjunction with other time functions, such as HOUR, SECOND, and TIME, to help manipulate and analyze time data in Excel.