Error while creating calculated column

Question

Hi,

We want to create a simple calculated column based on two existing date/time columns. Each time we try to add this new column, we get a "bad syntax" error message. Here is an example:

Correlation ID: b8bdcf9e-80aa-8000-dc2e-1bbbbxxxx

Date and Time: 04.04.2019 11:48:54

The formula looks very simple and it's based on official MS tutorial https://support.office.com/en-us/article/Examples-of-common-formulas-in-SharePoint-Lists-D81F5F21-2B4E-45CE-B170-BF7EBF6988B3

Example:

=TEXT([Column2]-[Column1],"h:mm")

Our formula:

=TEXT([CourseEnd]-[CourseStart],"h:mm")

Both of the date/time columns are standard. Here are the screenshots:

Can you tell us why it does not work or resolve the correlation ID given above?

Best Regards

Artur

[PII is masked by Eli Qian MSFT Support]

Answer 1

Hi Artur,

According tothis article,it mentions that All example formulas in this topic use commas "," as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons ";" as the delimiter character.

I think that German is the country which needs to use semi-colons ";" to replace commas "," in the formula. I also check this point on my site. I find it works when I change commas into semi-colons in the formula: =TEXT([Column2]-[Column1];"h:mm")

Hope this is clear for the situation. Feel free to let us know if it works fine on your end.

Best Regards,

Eli

Answer 2

Thank you!

I will try to find out what are those countries for future cases.