Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Need to Convert a Duration Lookup Field to Numeric

I have a Duration Lookup field from another table, and I want to create a checkbox formula that says yes or no if the lookup field value is greater than zero. The ultimate goal is to have a checkbox t...
Formulas and functions
Quickbase Automations
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The corrected formula is this

IF([TSK - Est. Edit Time] > Hours(0), TRUE)

or you can also write is as just this


[TSK - Est. Edit Time] > Hours(0)


QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
In fact, Zero seconds is equal to zero minutes is equal to zero hours is equal to zero days is equal to zero weeks.

Zero duration is zero duration no matter the Units.

So we can use Hours(0) or Weeks(0) or Seconds(0) to test against and the result would be the same.