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!
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!
Awesome. Glad you found something!