A to Z of Excel Functions: The MINUTE Function
6 June 2022
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the MINUTE function.
The MINUTE function
This function returns the minutes of a time value (expecting a serial number). The MINUTE is given as an integer, ranging from zero  to 59. The MINUTE function employs the following syntax to operate:
The MINUTE function has the following argument:
- serial_number: this is required and represents the time that contains the minute you want to find. Times may be entered as text strings within quotation marks (e.g. "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")).
It should be further noted that:
- time values are a portion of a date value and are represented by a decimal number (e.g. 12:00 PM is represented as 0.5 because it is half of a day).
Please see my example below:
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.
A full page of the function articles can be found here.