@Minute (Formula Language)

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

Syntax

@Minute( time-date )

Parameters

time-date

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

Return value

minutes

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.

Usage

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.

Examples

  1. This example returns 30.
    @Minute([9: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.
    @Minute(Time) 
  4. This example returns 59 if the Date field contains: 7/30/95 9:59:59.
    @Minute(Date)
  5. This example returns 00 if the current document's created date was 9/29/95 3:00:12 A.M.
    @Minute(@Created)