MINUTE function - The function converts a serial number into a minute in Excel

MINUTE function: The function returns the minute value of a time value. Minutes are returned as integers between 1 and 59.

The following article details how to use the MINUTE function, the function converts a serial number into a minute in Excel.

Description: The function returns the minute value of a time value. Minutes are returned as integers between 1 and 59.

Syntax : MINUTE (serial_number) .

Inside:

serial_number is the time value that wants to separate the minute value.

For example: Separate the minute value in the following time value:

MINUTE function - The function converts a serial number into a minute in Excel Picture 1MINUTE function - The function converts a serial number into a minute in Excel Picture 1

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

MINUTE function - The function converts a serial number into a minute in Excel Picture 2MINUTE function - The function converts a serial number into a minute in Excel Picture 2

Press Enter -> minute values ​​are separated in time value:

MINUTE function - The function converts a serial number into a minute in Excel Picture 3MINUTE function - The function converts a serial number into a minute in Excel Picture 3

Similarly copying the formula for the remaining cells results:

MINUTE function - The function converts a serial number into a minute in Excel Picture 4MINUTE function - The function converts a serial number into a minute in Excel Picture 4

In case you enter the wrong value of minutes, it exceeds 59 function returns #VALUE!

MINUTE function - The function converts a serial number into a minute in Excel Picture 5MINUTE function - The function converts a serial number into a minute in Excel Picture 5

Above is the usage and some special cases when using the Minute function .

Good luck!

5 ★ | 2 Vote