United Kingdom
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers. MINUTE
Applies to: Microsoft Office Excel 2003
Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59. Syntax MINUTE(serial_number) Serial_number is the time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")). Remarks Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5, since it is half of a day). Example The example may be easier to understand if you copy it to a blank worksheet.
|
Printer-Friendly Version
Show All
Hide All
| Related Web Sites |
| ||||||
