How to Use the MINUTE Function in Excel
Today, we will explore the MINUTE function in Excel and Google Sheets, which is utilized to extract the minute portion from a specific time.
Basic Syntax
The syntax for the MINUTE function is straightforward and identical in both Excel and Google Sheets:
MINUTE(serial_number)serial_number– Represents the time from which the minute will be extracted.
Examples
Let’s examine some examples to understand how the MINUTE function operates:
Example 1: Extracting Minutes from a Specific Time
Consider a scenario where cell A1 contains the time 10:25:35.
| Data | Formula | Result |
|---|---|---|
| 10:25:35 | =MINUTE(A1) | 25 |
In this example, the MINUTE function successfully extracts the minute, 25, from the given time 10:25:35.
Example 2: Using with Time Function
The MINUTE function can also be effectively integrated with the TIME function to extract minutes from a manually constructed time.
For instance, to determine the minute component of the time 03:45:00, which isn’t stored directly in a cell, use the following:
| Formula | Result |
|---|---|
| =MINUTE(TIME(3,45,0)) | 45 |
This formula computes to 45, extracting the minute portion from the manually specified time of 03:45:00.
Conclusion
The MINUTE function in Excel and Google Sheets is an invaluable tool for isolating the minute part of a time. With the guidance provided in the examples above, you can now seamlessly utilize the MINUTE function in your spreadsheets to effectively handle time-based data.
More information: https://support.microsoft.com/en-us/office/minute-function-af728df0-05c4-4b07-9eed-a84801a60589