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

MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells,

Read More »

RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel,

Read More »
Scroll to Top