MINUTE function - The function returns minutes of a time value in Excel

The following article introduces you to the MINUTE function - one of the functions in the date and time group is very popular in Excel.

MINUTE function - The function returns minutes of a time value in Excel Picture 1

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:

MINUTE function - The function returns minutes of a time value in Excel Picture 2

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

MINUTE function - The function returns minutes of a time value in Excel Picture 3

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

MINUTE function - The function returns minutes of a time value in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

MINUTE function - The function returns minutes of a time value in Excel Picture 5

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

MINUTE function - The function returns minutes of a time value in Excel Picture 6

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

Good luck!