# How to use Excel MINUTE Function

How to use Excel MINUTE Function2016-04-28T06:56:50+00:00

## Quick Intro

Use Excel MINUTE Function to get a minute as a number from a time value range from 0 to 59. In simple words, it will return the only minute from a time. For example from 18:43 it will return 43.

## Syntax

MINUTE(serial_number)

• serial_number A valid time value from which you want to get the minute as a number.

• You can also input time as a text directly into the function. For example, =minute(“08:32 PM”).
• If you refer to a blank cell it will return 0 in the result.
• Excel stores date as a number, time represents in the decimals in that number.

## Examples

In the below example, we have used the minute function to extract minute value from different time values.

• You can use it to get the minute number from a time value.
• You can also extract the minute number from a date in which you have time.
• The minute function is only concerned with the decimal part of a serial number.

## What’s Next?

To learn more about Excel MINUTE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There are also you have SECOND | HOUR functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.