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?
@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
1 Like
Awesome. Glad you found something!