Formulas > =MINUTE()
How To Use MINUTE() Function in Google Sheets
Description
How To Actually Use MINUTE() in Sheets
MINUTE(time)
Try MINUTE yourself
In cell B1, use the MINUTE function to extract the minute component from the time in cell A1. The result should be a numeric value representing the minutes.
Hints (3)
-
Make sure the time in A1 is formatted correctly.
-
The MINUTE function takes a single argument.
-
The result will be a number between 0 and 59.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the MINUTE() formula:
Generate a MINUTE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MINUTE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MINUTE() formula