FormulaCraft

MINUTE

MINUTE returns the minutes portion of a time value as an integer between 0 and 59. It is useful when you need to round times to the nearest quarter-hour, calculate elapsed minutes, or filter events occurring at specific minute marks.

Excel
=MINUTE(TIMEVALUE("14:37:00"))
Google Sheets
=MINUTE(TIMEVALUE("14:37:00"))
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

CallTimeMinutes
0.375
0.604861111
0.916666667
0.500694444

=MINUTE(TIMEVALUE("14:37:00"))→37

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Store your time values as proper Excel time serial numbers in column A.
  2. 2In cell B2 type =MINUTE(A2) to get the minutes portion.
  3. 3Combine with HOUR and SECOND if you need full time decomposition for rounding or formatting.

Need a version for your data?

Try: “Extract the minutes from a list of timestamps to see if calls were on the hour or not”

Related

TODAY / DATEDIFEOMONTHNETWORKDAYS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: