Google Sheets
MINUTE function in Google Sheets
Returns the minute component of a specific time, in numeric format.
=MINUTE(time)MINUTE syntax and parameters
One argument, one required.
- timeanyRequired
The time from which to calculate the minute component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.
MINUTE examples
Formulas you'll actually reuse.
The minute part of a 17:15 clock-out time:
=MINUTE(C2)Result
15The leftover minutes of a shift — 08:30 to 17:15 is 8 h 45 min:
=MINUTE(C2 - B2)Result
45
MINUTE in Excel
Same name — your formula ports as-is.
Try MINUTE in the playground
Edit the example — nothing to install.
Preloaded with the MINUTE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- DATEConverts a provided year, month, and day into a date.DateExcel
- DATEDIFCalculates the number of days, months, or years between two dates.DateExcel
- DATEVALUEConverts a provided date string in a known format to a date value.DateExcel
- DAYReturns the day of the month that a specific date falls on, in numeric format.DateExcel
- DAYSReturns the number of days between two dates.DateExcel
- DAYS360Returns the difference between two days based on the 360 day year used in some financial interest calculations.DateExcel