Excel Tutorial – MINUTE

The MINUTE function in Microsoft Excel is a built-in function that allows you to extract the minute component from a given time value. It takes a single argument, which is the time value that you want to extract the minutes from, and returns the minute component as a number between 0 and 59.

To use the MINUTE function in Excel, follow these steps:

1. Open a new or existing worksheet in Excel.
2. Select the cell where you want to display the result of the MINUTE function.
3. Type the following formula in the cell: =MINUTE(time_value)
4. Replace “time_value” with the cell reference or the time value that you want to extract the minutes from. For example, if the time value is in cell A1, you would use the formula =MINUTE(A1).
5. Press Enter to calculate the result of the MINUTE function.

For example, let’s say you have a list of times in column A, and you want to extract the minute component from each time and display it in column B. You can use the MINUTE function as follows:

1. In cell B1, type the formula =MINUTE(A1)
2. Press Enter to calculate the result.
3. Select cell B1, and then drag the fill handle (the small square in the bottom-right corner of the cell) down to fill the formula in the remaining cells of column B.

This will extract the minute component from each time in column A and display it in column B.

Note: The MINUTE function returns a number between 0 and 59, so if you want to display the result as a time value, you may need to use the TEXT function to format the result as a time value. For example, you can use the formula =TEXT(MINUTE(A1), “00”) to display the result as a two-digit number, with a leading zero if the result is less than 10.