Excel MINUTE Function

HomeExcel FunctionsExcel MINUTE Function (Example + Sample File)

What is EXCEL MINUTE FUNCTION

The Excel MINUTE Function is listed under Microsoft Excel's Time Functions category. It returns the minute value from a valid time. Time value is made up of, hours, minutes, and seconds and MINUTE function takes the minute value and ignores the rest of all.

How to use it

To learn how to use the MINUTE function in Excel, you need to understand its syntax and arguments:

Syntax

MINUTE(serial_number)

Arguments

  • serial_number: A valid time from which you want to get the minute value.

Notes

  • 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.

Example

To master the MINUTE function we need to try it out in an example, so make sure to check out the below one:

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

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.