MINUTE function
MINUTE calculates the minute for an internal time value. The minute is returned as a number 0 - 59.
Syntax
MINUTE(number)
number is a time value represented by a decimal for which the minute is to be returned.
Example
=MINUTE(NOW()) returns the current minute.
=MINUTE(C4) returns 20 if the content of C4 is 17:20:00.
=MINUTE(0,01388889) returns 20 as it is the same as =MINUTE(20/(24*60)) and corresponds to 12/30/1899 00:20:00.