TIME

Use the TIME function to create a time value from hour, minute, and second values, which can be literals, fields, or formulas that return Number values.

Use

TIME( hour, minute, second )
Create a time from the hour, minute and second.

Parameter	Required	Description
hour	Yes	the value of the hour (0 to 23)
minute	Yes	the value of the minute (0 to 59)
day	Yes	the value of the second (0 to 59)

Returns

Time

Examples

Establishing a Fixed Daily Cutoff

You can use the TIME function in a Variable Update or Property formula to establish a standardized daily deadline for processing specific requests.

• Scenario: A finance team requires that all "High Priority" expense claims be marked with a same-day processing deadline of exactly 4:30 PM.
• Formula: TIME(16, 30, 0)
• Logic:
  • 16: Represents the 16th hour of the day (4 PM).
  • 30: Sets the minutes to 30.
  • 0: Sets the seconds to 0.
• Result: This creates a literal Time value of 4:30 PM, which can then be assigned to an activity's Due On or Expire On property.

Constructing a Precise Date/Time Stamp

In GoApprove, you can combine the TIME function with a date to create a full Date/Time value, which is useful for scheduling activities based on user input.

• Scenario: A user submits a "Maintenance Request" and provides their preferred start hour (as a number, e.g., 9) in a Trigger form. You need to combine this hour with today's date to set the exact start time for a technician.
• Formula: TODAY() + TIME(@Trigger.out.PreferredHour, 0, 0)
• Logic:
  • TODAY(): A function that returns the current date.
  • @Trigger.out.PreferredHour: Pulls the numeric value (e.g., 9) from the trigger form.
  • TIME(..., 0, 0): Converts that number into a valid Time object (9:00:00 AM).
• Result: By using the plus (+) arithmetic operator, the system joins the date and time to produce a combined Date/Time value (e.g., 23/05/2024 9:00 AM).