Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > MINUTE
 

MINUTE(serial_number)

 
 Returns the number of minutes given a date serial number.

 serial_numberThe time that contains the minutes you want to find.

 REMARKS
 
  		• The "serial_number" can be a time, value, cell reference or a text string in a time format.
     
  		• If "serial_number" < 0, then #NUM! is returned.
     
  		• If "serial_number" is not a valid time or date, then #VALUE! is returned
     
  		• You can obtain the serial number from a time by using the TIME() function.
     
  		• You can use the TIMEVALUE() function to return the serial number representing the time in a text format.

     EXAMPLES
     
     AB
    1=MINUTE(B1) = 3011:30:15
    2=MINUTE("11:30:15") = 30=NOW() = 20:17:34
    3=MINUTE(B2) = 17=NOW() = 39294.846
    4=MINUTE(0.678) = 16 
    5=MINUTE(TIME(15,10,55)) = 10 
    6=MINUTE(TIMEVALUE("6:45:22 PM")) = 45 
    7=MINUTE(0) = 0 
    8=MINUTE(-10) = #NUM! 
    9=MINUTE("some text") = #VALUE! 
    		 
     Functions - M | Index - M | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top