MINUTE function
The MINUTE function is used to extract minutes from a time value in Excel. It returns a number from 0 to 59, corresponding to the minute component of the passed time.
This is convenient when analyzing timestamps, logs, events, and any situations when you need to work with time components separately.
Syntax
=MINUTE(time)- time — time value or reference to a cell containing time.
Usage examples
=MINUTE(A1)If cell A1 contains the time 14:32:45, the result will be 32.
=MINUTE(NOW())Extracts the number of minutes from the computer’s current time.
=MINUTE(TIME(8, 15, 0))Result — 15, since that’s how many minutes are specified in the TIME function.
Other Date and Time functions in Excel
TIMEVALUE, TIME, YEAR, DATE, DATEVALUE, EDATE, DAY, WEEKDAY, YEARFRAC, EOMONTH, MONTH, WEEKNUM and WEEKNUM.ISO, WORKDAY, DATEDIF, TODAY, SECOND, NOW, NETWORKDAYS
Like the article? Help its author! Buy !SEMTools, it has lots of useful instruments to process text data.
This post is also available in RU.