# I want to calculate if a business is open with respect to current hours

**URL:** https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828
**Category:** Ask for Help
**Created:** [April 18, 2022, 3:09am UTC](https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828 "2022-04-18T03:09:29Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![David\_Cura](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_cura/32/37628_2.png) [@David\_Cura](https://community.glideapps.com/u/David_Cura)
#### Post date: [April 18, 2022, 3:09am UTC](https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828/1 "2022-04-18T03:09:29Z")

</div>

Hello everyone. Thanks for your help.

I want to calculate the businesses are open regarding the current hours.

For this I need to create the following calculation.

Current time  
=\> Opening hours  
Y  
Current time  
=\< Closing time

I tried using if then else but couldn’t. Do you have any idea?

Thank you!

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 18, 2022, 3:11am UTC](https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828/2 "2022-04-18T03:11:04Z")

</div>

Do you ever need to deal with users in multiple time zones?

Do you have a screenshot of how you tried setting up your IF column?

---

<div class="post-metadata">

### Author: ![David\_Cura](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_cura/32/37628_2.png) [@David\_Cura](https://community.glideapps.com/u/David_Cura)
#### Post date: [April 18, 2022, 3:16am UTC](https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828/3 "2022-04-18T03:16:59Z")

</div>

@Jeff_Hager

I just found the solution in one of your answers. You helped me think about how to use the IF column to make it work.

Thanks for your prompt response!

[Solution](https://community.glideapps.com/t/opening-and-closing-hours-of-a-store/38351/5)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 18, 2022, 3:45am UTC](https://community.glideapps.com/t/i-want-to-calculate-if-a-business-is-open-with-respect-to-current-hours/40828/4 "2022-04-18T03:45:51Z")

</div>

Awesome. Glad you found something!