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...
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
6 years ago
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.