The MINUTE formula with example in Excel

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

Syntax

MINUTE(serial_number)

• serial_number: This is the time from which you want to extract the minute. It can be a cell reference, a time value, or a result of another function.

Example

Suppose you have a list of timestamps, and you want to extract the minute component from each timestamp.

Data

A
10:15 AM
3:45 PM
12:00 PM
6:30 AM
9:59 PM

You want to extract the minute component from each timestamp.

Steps

1. Enter the timestamps in column A (A1).

2. Use the MINUTE function to extract the minute component. In cell B1, enter the following formula:

   =MINUTE(A1)
   

3. Copy the formula from B1 down to B5.

Result

A	B
10:15 AM	15
3:45 PM	45
12:00 PM	0
6:30 AM	30
9:59 PM	59

Explanation of the Formula

• A1 is the cell containing the time value "10:15 AM".
• =MINUTE(A1) extracts the minute part (15) from the time value.

Another Example with Different Time Formats

Suppose you have times in different formats, and you want to extract the minute component.

Data

A
10:15:30 AM
15:45:10
00:00:00
06:30:45 AM
21:59:59

You want to extract the minute component from each time.

Steps

1. Enter the times in column A (A1).

2. Use the MINUTE function to extract the minute component. In cell B1, enter the following formula:

   =MINUTE(A1)
   

3. Copy the formula from B1 down to B5.

Result

A	B
10:15:30 AM	15
15:45:10	45
00:00:00	0
06:30:45 AM	30
21:59:59	59

By using the MINUTE function, you can easily extract the minute component from any time value, which is particularly useful for time analysis and calculations in Excel.