Skip to main content
Question

Need to setup checkbox formula based on hours:minutes

  • Jun 5, 2019 7:43 PM UTC
  • 0 replies
  • 68 views
I have a formula field that returns the hours:minutes of a technician onsite.  I want to use this field to create a checkbox formula that returns TRUE if the hours run over 4 hours and FALSE if it runs under 4 hours.  I keep getting errors regarding using the if function with a duration and I'm not sure how to get around this if at all possible.  Currently trying the syntax below but is not working.  Any help is appreciated.

If([day 1 time on site]>4,"TRUE","FALSE")

      This topic has been closed for replies.

      IF([field]>4,,)

      requires that [field] be numeric. You probably need to convert [day 1 time on site] (or the part of it that you want to evaluate) to numeric within this formula. Depending on the field type and format of [day 1 time on site] that may require a little bit of additional maneuvering.
      Jeffery,
      If the field type being tested is Duration then you will need ot test against a duration.

      If([day 1 time on site] > Hours(4),"TRUE","FALSE")
      Terms & ConditionsAccessibility statement