The MINUTE function is a simple date function that extracts just the minute from a given time. If you are working with times, but only care about the minutes, the MINUTE function lets you get rid of everything else. Remember that dates are really just saved as numbers by your spreadsheet with date formatting applied.
The MINUTE function returns the number of minutes from any given unit of time.
Example 1 – Plain and Simple
A few simple examples of the MINUTE function.
||Extract the minute value from 1:02.||2|
||Extract the minute value from 1:02 PM.||2|
||Extract the minute value from 2.75.||0|
||Extract the minute value from 2.56849.||38|
Tip: Sheets is interpreting a whole number and decimal as a number of days and a portion of a day. Therefore, 2.75 is 2 days and 18 hours. Thus, there are no minutes. See how dates and times work to make a little sense out of this.
Live examples in Sheets
Go to this spreadsheet for the examples of the YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND functions shown above that you can study and use anywhere you would like.