1. Write a < x < b instead of AND(a < x, x < b)

<aside> ✅ DO SUNRISE() < NOW() < SUNSET()

</aside>

<aside> ❌ DON’T AND(SUNRISE() < NOW(), NOW() < SUNRSET)

</aside>

2. Follow the standard numeric values for TIME function

<aside> ✅ DO TIME(1,30,0)

</aside>

<aside> ❌ DON’T TIME(0,90,0)

</aside>

Following the standard numeric values for hours, minutes and seconds to avoid confusions.

Syntax: TIME(hour, minute, second)

• hour: 0-23
• minute:0-59
• second:0-59

3. Use standard industry reference numbers

For example, in horticulture, a 5-minute time step is the standard reference for time series data. We recommend maintaining this interval in all your formulas. Consistency in using this reference will make it easier to detect errors, particularly when your time series graph records data every 5 minutes.

<aside> ✅ DO {Steps Passed} {Total Steps Per Day}

</aside>

<aside> ❌ DON’T {Hours Passed} {Total Hours Per Day}

</aside>