MINUTE

Using the Excel MINUTE Function

Summary

The MINUTE function in Excel can be used to return the minutes from a time value. The result will be an integer that ranges from 0 to 59. For example, 2:15 PM will return 15. The function does not pay attention to hours or date components if they are included. The MINUTE function is useful if you are given a list of times and are required to provide only the minute to another formula or function.

Syntax

=MINUTE (serial_number)

Syntax Breakdown

Serial_number
A required field that contains the time where you would like to find the minutes. Time can be entered as text strings (be sure to use quotation marks), decimal numbers, or the output from other formulas or functions.

Excel MINUTE Examples



Other Notes

Time Values as Decimals
Time values can be represented as a decimal number. An example would be 0.5 to represent 12:00 P.M. since 12:00 P.M. is half of one day.

Excel stores dates and times as serials numbers, which may cause you to occasionally want to verify that dates and times are being recognized correctly. This can be achieved by formatting the time as a number.

MINUTE Time Value as Decimal