MINUTE function

Returns only the minute of a time value. The minute is given as an integer, ranging from 0 to 59.

Syntax

MINUTE(serial_number)

Argument

Description

Remarks

serial_number

The time that contains the minute you want to find.

  • Times may be entered as text strings enclosed in 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")).

General remarks

Time values are a part of a date value and are represented by a decimal number (for example, 12:00 PM is represented by 0.5 because it is exactly halfway through a day).

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
AB
Time 
4:48:17 PM 
FormulaDescription (Result)
=MINUTE(A2) Minutes of the time in cell A2 (48)
Rate this content:
Not helpfulSomewhat helpfulHelpfulVery helpfulSolved my problem 
 
Share your feedback about this topic