@Minute (Formula Language)

Extracts the number of minutes from the specified time-date.


@Minute( time-date )



Time-date or time-date list. The value with the minute that you want to extract.

Return value


Number or number list. The number of minutes in the minute part of the time. Returns -1 if the time-date provided contains only a date and not a time value.


If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.


  1. This example returns 30.
  2. This example returns 15 and 30 in a list.
    @Minute([9:15] : [9:30])
  3. This example returns 56 if the Time field contains 8:56:34 P.M.
  4. This example returns 59 if the Date field contains: 7/30/95 9:59:59.
  5. This example returns 00 if the current document's created date was 9/29/95 3:00:12 A.M.