# Daily 2 hours time intervals

**URL:** <https://community.glideapps.com/t/daily-2-hours-time-intervals/76585>\
**Category:** Ask for Help\
**Created:** [September 24, 2024, 7:11am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585 "2024-09-24T07:11:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\
**Post date:** [September 24, 2024, 7:11am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585/1 "2024-09-24T07:11:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 24, 2024, 7:23am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585/2 "2024-09-24T07:23:38Z")

</div>

Use a Math column to determine the hour of the day:

```auto
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…

---

<div class="post-metadata">

**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\
**Post date:** [September 24, 2024, 7:44am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585/3 "2024-09-24T07:44:12Z")

</div>

Thank you! I will try that!

---

<div class="post-metadata">

**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\
**Post date:** [September 24, 2024, 9:57am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585/4 "2024-09-24T09:57:27Z")

</div>

It worked!!! 💯

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 1, 2024, 9:58am UTC](https://community.glideapps.com/t/daily-2-hours-time-intervals/76585/5 "2024-10-01T09:58:25Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.