Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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)
IF([TSK - Est. Edit Time] > Hours(0), TRUE)
or you can also write is as just this
[TSK - Est. Edit Time] > Hours(0)
- SuryaExpert7 years agoQrew Assistant CaptainMark, 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?
- QuickBaseCoachD7 years agoQrew CaptainIn 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.