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




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

DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria. =DSUM

Read More »

Autosum Function

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just

Read More »
Scroll to Top