The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.

Syntax:

=MINUTE(serial_number)

Arguments

serial_number – (required) The time that contains the minute you want to extract.

MINUTE Function Usage Examples:

Let’s look at the following example that shows how the Minute is removed from a time value in Excel.

MINUTE Function

Here are some other usage examples. Excel ignores hours, seconds, and dates when using the MINUTE function. Decimal numbers, such as .11, are treated as a % of 24 hours. For example, Excel calculates 11% of 24 hours and returns 38.

Usage Errors

#VALUE! error – The serial_number is not a valid Excel time.

Leave a Reply

CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This

Read More »

Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to

Read More »

NPER Function

The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The

Read More »
Scroll to Top