The MINUTE function returns the number of minutes in a time value.

• The syntax for the function is MINUTE(serial_number) . The argument "serial_number" is the time value of which the umber of minutes is extracted. Resulting in a value is between 0 and 59.
  
  

The "serial_number" can be in the form of a string, a decimal or the result of a formaula.
For example: MINUTE("6:35:42") = 35 or when working with decimals MINUTE(0.035) = 50 .This because 0.035 is interpreted as a "time value" representing a time of 12:50:24 AM and extracted a value of 50 minutes.