MINUTE ( time-value )

Description: Computes the minute for the date and/or time having the given time-value.

Arguments:

Name	Type	Description
time-value	number	The date and/or time whose minute is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its integer part is ignored, or as a string-constant having any valid date and/or time format, in which case, any date information shall be ignored.

Return Type and Value: number – The minute for the date and/or time having the given time-value. The returned value shall be in the range 0–59.

However, if time-value is out of range for the current date base value, #NUM! is returned.

[Example:

MINUTE(DATE(2006,2,26)+TIME(2,10,20)) results in 10
MINUTE(TIME(22,56,34)) results in 56
MINUTE(0) results in 0, since serial value 0 represents 00:00:00
MINUTE(10.5) results in 0, since serial value .5 represents 12:00:00
MINUTE("22-Oct-2001 10:53:12") results in 53
MINUTE("10:53:12 pm") results in 53
MINUTE("22:53:12") results in 53

end example]