The MINUTE function in Google Sheets is designed to extract the minute component from a specified time value. This can be particularly useful in time calculations, data analysis, or scheduling tasks where minute precision is required in your datasets.

Syntax

MINUTE(time)

• time: The time value or reference from which the minute is to be extracted. This can also be a reference to a cell containing a time format.

Example #1

=MINUTE("10:25:30")

This function call extracts the minute from the specified time, resulting in 25.

Example #2

=MINUTE(A1)

If cell A1 contains the time 12:45:00, this function will return 45, indicating the minutes portion of that time.

Example #3

=MINUTE(TIME(14, 15, 30))

Here, the function retrieves the minute from a specified time created using the TIME function, resulting in 15.

Error handling

• VALUE! – This error occurs when the input provided is not a valid time format or a cell containing a time reference.
• NUM! – This happens when the time value is out of the accepted range, usually if it is negative or exceeds 24 hours.

Conclusion

In summary, the MINUTE function is a simple yet powerful tool within Google Sheets that allows users to dissect time values and retrieve minute components efficiently. Understanding and utilizing this function can enhance your data manipulation capabilities, particularly in time-sensitive applications.