The Excel MINUTE Function

Function Description

The Excel Minute function returns an integer representing the minute component of a supplied Excel time.

The syntax of the function is:

MINUTE( serial_number )

where the serial_number argument is the time from which you want to extract the minute component. This may be supplied to the function as either:

Note that, if the serial_number argument contains a date and time, the Minute function ignores the date part of the argument.


Minute Function Examples

Four examples of the Excel Minute function are shown in column B of the following spreadsheet.

 Formulas:
 AB
1 =MINUTE("13:35:55")
213:35:55=MINUTE( A2 )
308:17:55=MINUTE( A3 )
412/09/2015 08:55=MINUTE( A4 )
 Results:
 AB
1 35
213:35:5535
308:17:5517
412/09/2015 08:5555

For further information and examples of the Excel Minute function, see the Microsoft Office website.


Minute Function Error

If you get an error from the Excel Minute Function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if the supplied serial_number is not a valid Excel time.