I am struggling with the syntax of the following equation:
=IFS(OR(start="";end="");"";(end-start)*24<10;(end-start)*24-0.5;(end-start)*24>=10;(end-start)*24-1.0)
The Google sheet can’t parse the equation due to a syntax error. ChatGPT and other AIs are not helpful. What is the problem here?
Are there any tools to test a google sheet equation?
Thanks for your help!