MINUTE
The MINUTE function extracts the minute from a time value. It returns an integer from 0 to 59. Use it to analyze minute-level data from time values.
Syntax 🔗
=MINUTE(time)
time | The time from which you want to extract the minute component. |
About MINUTE 🔗
Use the MINUTE function in Excel to extract the minute portion from a time value. This function is helpful for time-related tasks, such as scheduling, time tracking, or calculating durations, when you need to focus on minutes within your spreadsheets.
Examples 🔗
If you have a cell (A1) containing the time 10:45:30, using the formula =MINUTE(A1) will return 45, which represents the minute component of the time.
Assuming cell B1 contains the time 14:25:00, the formula =MINUTE(B1) will output 25 as the minute value of the given time.
Notes 🔗
Use the MINUTE function to extract the minute component from a valid Excel time value. Make sure the time data you provide is in a format recognized by Excel.
Questions 🔗
If the cell reference you provide to the MINUTE function does not contain a valid time value, it will result in a #VALUE! error. Make sure the input time data is correctly formatted as a time value prior to using the MINUTE function.
Can the MINUTE function handle time values that extend beyond 24 hours?Yes, the MINUTE function can extract the minute component from time values that extend beyond 24 hours without any limitations. It focuses solely on the minute part of the provided time, regardless of the overall duration.
Is the output of the MINUTE function in a specific format or unit?The output of the MINUTE function is returned as an integer representing the minute component of the given time value. The format is a whole number corresponding to the minute part of the time, ranging from 0 to 59.