## Examples

`MINUTE("007:14:21")`

: 14

`MINUTE(TIMENOW() - "00:00:00")`

: Minutes since the top of the hour; the current minute of the hour. See also: *TIMENOW()*.

#### Minutes in Duration

*MINUTE()* merely extracts the minutes component from a *Duration* value; it does not compute the number of minutes the *Duration* value represents in total. To compute the total minutes comprising a *Duration* value:

`(`

(HOUR([Duration]) * 60)

+ MINUTE([Duration])

+ (SECOND([Duration]) / 60.0)

)

`(HOUR([Duration]) * 60)`

computes the number of minutes represented by the hours component.`MINUTE([Duration])`

gathers the number of minutes specified by the minutes component.`(SECOND([Duration]) / 60.0)`

computes the fractional minute represented by the seconds component.

#### Common Problems

`MINUTE(NOW())`

(or any *DateTime* or *Time* value in place of *NOW()*) causes Expression Assistant to complain, *Parameter 1 of function MINUTE is of the wrong type*. The argument must be a *Duration* value, not a *DateTime* or *Time* value. To fix, convert a *DateTime* value to a *Time* value with *TIME()*, then subtract a zero time to convert a *Time* value to a *Duration* value: `MINUTE(TIME(NOW()) - "00:00:00")`

. See also: *NOW()*, *TIME()*.

## Syntax

**MINUTE(** *how-long* **)**

## Arguments

*how-long*(*Duration*)

## Return Value

*Number*: the number of whole minutes explicitly specified by *how-long* if identifiable, or 0 if a minute is not found.

`MINUTE(...)`

is equivalent to `(NUMBER(INDEX(SPLIT(TEXT(...), ":"), 2)) + 0)`

when `...`

is a *Time* value. See also: *INDEX()*, *NUMBER()*, *SPLIT()*, *TEXT()*.