I’m looking for a way to add a condition to count the time spent on a single task so that the time can only be counted between 9 am and 5 pm. Outside these hours, the time should be automatically stopped.
I created an additional column with the formula: AND(Hour(Now())>9,Hour(Now())<17) which returns True or False. Unfortunately, I can’t use this column in automation as a condition.
Hi,
Welcome the community!
You can create a workaround using date and time columns along with automation rules…and you could set up an additional rule that checks if the current hour is outside of 9 am to 5 pm and then stops or resets the timer accordingly
Hope this helps!
Cheers,
Harsh
We empower businesses to unlock Monday’s full potential, driving growth and operational excellence.
Learn more about us on Fario Consulting
thanks but can you show me an example? which automation to use? I’ve tried several options and can’t achieve what I want.