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
    Commented Jul 25, 2016 at 14:49

1 Answer 1


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 and acknowledge you have read our privacy policy.

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