Skip to main content

MINUTE

Use the MINUTE function to return the minutes of a time value. The minute is given as a number, ranging from 0 to 59.

Use​

MINUTE( time )
Returns the minute of a time or date/time value.

ParameterRequiredDescription
timeYesthe time or date/time that contains the minute to return

ReturnsNumber

Examples​

Output Validation (Enforcing Specific Appointment Slots)​

You can use MINUTE in an Output Validation Formula to ensure that a user schedules an event only at specific times, such as on the hour or the half-hour.

  • Scenario: A "Resource Booking" form requires that all "Start Times" be set to either :00 or :30 to prevent overlapping appointments.
  • Formula: ASSERT(OR(MINUTE(this) = 0, MINUTE(this) = 30), "Appointments must be scheduled on the hour or the half-hour.")
  • Logic:
    • this: Refers to the time value the user is currently entering into the capture widget.
    • MINUTE(this): Extracts the numerical minute from the user's input.
    • OR(...): Checks if that number is equal to 0 or 30.
    • ASSERT: If the result is FALSE (e.g., the user enters 2:15 PM), the system displays the custom error message and prevents submission.

Conditional Routing (Submission Timing)​

You can use MINUTE within a Path Condition Formula to route an approval differently based on when it was started.

  • Scenario: A "Flash Report" approval is routed to an "Express Review" team if the request is submitted within the first 15 minutes of the hour; otherwise, it follows the standard path.
  • Formula (for the Express Path): MINUTE(@prop.StartedOn) <= 15
  • Logic:
    • @prop.StartedOn: This system property retrieves the exact Date/Time the approval run began.
    • MINUTE(...): Strips away the date, hour, and seconds to look only at the minute.
    • Result: For a run started at 9:12 AM, the function returns 12. Since 12 is less than or equal to 15, the formula evaluates to TRUE, and the approval follows the "Express" branch.

Pro Tip: If you are working with a time that is currently stored as Text (e.g., "14:45"), you must first use the TIMEVALUE function to convert it into a Time data type before the MINUTE function can process it.

ON THIS PAGE