How to Use the MINUTE Function in Excel

This guide explains how to use MINUTE Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns minutes of a time value. Minutes are returned as integers, values from 0 to 59.

Syntax: MINUTE (serial_number)

Where: serial_number is the time value you want to calculate minutes, the time value can be entered as a string or as a decimal number or a combination of both.

Attention:

- The time value is part of the date value and is expressed as a decimal.

For example:

Calculate minute values in the following time formats:

- In the cell to calculate enter the formula: = MINUTE (F7).

- Press Enter -> minute value in the time value is:

- Similarly copying the formula for the remaining values results:

- Where the time value is invalid -> the function returns the error value #VALUE!

Above are instructions and some specific examples of working with MINUTE function .

Good luck!