Using the Excel MINUTE Function
SummaryThe 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.
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.
Other NotesTime 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.