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:

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

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

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

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

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

Similarly copying the formula for the remaining cells results:

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

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

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

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

Good luck!

Update 19 May 2020

You should read it