I would like to show some information regarding how the energy of the body works, based on 2-hours daily time intervals. The time intervals are as follow: between 7-9 am, 9-11 am etc… all around the 24h clock. How do I set this up so that the right interval is displayed and therefore I can display the information related to the current time interval? That it also is adjusted to the user’s timezone.
Use a Math column to determine the hour of the day:
Hour(Now)
Substitute Now in the above with the special “Now” current time value.
Then you can use an if-then-else column to decide what to do with that. Given that you have regular 2 hour intervals, you might have something like the following:
- If Hour is greater than 22, then X
- If Hour is greater than 20, then Y
- If Hour is greater than 18, then Z
- etc…
1 Like
Thank you! I will try that!
It worked!!! 
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.