The formula contains a syntax error or is not supported.

I get this error and I tried this formulas: =TEXT([LeavingTime]-[ArrivingTime],"h") =DATEDIF([ArrivingTime], [LeavingTime],"d")

where ArrivingTime, LeavingTime and TimeSpend are Date time columns Which regional settings should I use or is there any other problem?

  • Is using a workflow an Option?
    – Andrew
    Jul 25 '16 at 14:49

Most likely the , is not the parameter separator in your language.

Just like with Excel you have to use the ; for most non-english languages

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.