Forum Discussion

JeffreyJones1's avatar
JeffreyJones1
Qrew Trainee
6 years ago

Need to setup checkbox formula based on hours:minutes

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 run...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
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")
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Many new users get tripped up by formuals involving dates and time and durations, especially Durations.

If you look back on your original formula, you will see that Quick base would have no way to know if you meant 4 minutes or 4 hours or 4 days or 4 weeks.

So that is why we needed to convert that 4 to a Duration.