Author: Oscar Cronquist Article last updated on April 19, 2018

Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 to 59.

Formula in cell C3:


Excel Function Syntax



serial_number Required. An Excel time value that you want to extract the minute from.


Excel time (serial_number) is actually a number ranging between 0 and 1 in Excel and then formatted as time.

Example, 12:00 PM is represented as 0.5 because it is half of a day, you can verify this by typing 12:00 PM in a cell and then change the cell formatting to general.