Syntax. MINUTE(serial_number)
Definition. This function extracts the minute from a serial number (a time with or without a date). The minute is returned as an integer from 0 through 59.
Arguments
serial_number (required). A valid time (and a date, if applicable)
Background. With this function, as well as with the HOUR() and SECOND() functions, you can determine a valid time and use its components for other calculations.
You can enter times as strings enclosed in quotation marks (as in “06:43”), as decimal numbers (as in 0.27986111 for 06:43), or as the result of other formulas and functions.
Example. Assume that you need to calculate the minutes after the full hours.
Here are example formulas:
=MINUTE("06:43")
returns 43
minutes.
=MINUTE("12/24/2010 18:12")
returns 12
.
=MINUTE(NOW())
returns the current minute.
Sample Files
Use the MINUTE worksheet in the Date_Time.xls or Date_Time.xlsx sample file. The sample files are found in the Chapter07 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.138.123.106