Minute

Returns a number representing the minute portion (0 to 59) of a specified time.

Format 

Minute ( time )

Parameters 

time - any time value or field of type time

Data type returned 

number

Originated in version 

6.0 or earlier

Notes 

  • If no minute value is specified, 0 is returned.

Example 1 

Minute ( "12:15:23" ) returns 15.

Example 2 

Hour ( Duration ) + ( Minute ( Duration ) / 60 ) returns 2.5, if the Duration time field contains 2:30:15.