MINUTE function

MINUTE calculates the minute for an internal time value. The minute is returned as a number 0 - 59.



number is a time value represented by a decimal for which the minute is to be returned.


=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.