MINUTE

Formula Explanation

Returns the minutes from a time value. Minutes is an integer between 0 and 59.

Formula Syntax

Result column input: MINUTE(column number)

The MINUTE function syntax has the following argument:

• Column number (required): A time value that contains the minutes you want to retrieve. There are multiple ways to input a time value:

  • A text string with quotes (e.g., "6:45 PM")
  • A decimal number (e.g., 0.78125 represents 6:45 PM)
  • The result of another formula or function (e.g., TIMEVALUE("6:45 PM"))

Usage Examples

Retrieve the minutes from the values in column DQ2. Write the result in column DQ3.

DQ2 = MINUTE(DQ2)

✉️ Ask Tablize