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

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
Current time
=< Closing time

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

Thank you!

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?


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!


1 Like

Awesome. Glad you found something!