MINUTE

The MINUTE function extracts the minute from a time as a number between 0-59. For example, given a time of "7:45", MINUTE will return 45. The MINUTE function takes just one argument, serial_number, which must be a valid Excel date or a valid Excel time. Times can be supplied to the MINUTE function as text (e.g. "7:45 PM") or as decimal numbers (e.g. 0.5, which equals 12:00 PM). To create a time value from scratch with separate hour, minute, and second inputs, use the TIME function. The MINUTE function will "reset" to 0 every 60 minutes (like a clock). To work with minute values larger than 60, use a formula to convert time to decimal minutes. To use the MINUTE function, supply a time value: You can use the MINUTE function to extract the minute into a cell, or feed the result into another f