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)


SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
Mark, I thought of that, but the duration can be even a few minutes or seconds, or technically even milli seconds. So if the duration is less than 1 hour, and you are looking for the hours, I am not sure if it will show 0 or 0.x. You know what I mean?