How to use calculated time between in sharepoint

Örnvall Andreas 0

Hello i am doing this code in sharepoint lists but get syntax error when doing this, what can i do instead?

User's image

User's image

User's image

Answer accepted by question author

Jayden-P 13,280 Reputation points Microsoft External Staff Moderator

2025-12-18T08:17:01.14+00:00

Hi @Örnvall Andreas

I tried to reproduce your site, a Team site with default language in English, region is set to Swedish (Sweden).

The date format is YYYY-MM-DD. This formula works perfectly on my side.

=INT(EndTime-StartTime)&"d "&INT(MOD((EndTime-StartTime)*24;24))&"h "&ROUND(MOD((EndTime-StartTime)*1440;60);0)&"m"

If you need only date (with no time), try using this official formula from Microsoft.

=DATEDIF(StartTime;EndTime;"D")&" days"
Please sign in to rate this answer.

2 people found this answer helpful.
Örnvall Andreas 0 Reputation points

2025-12-19T07:04:54.6033333+00:00

Thanks, it did work now finally! really thankful!

Jayden-P 13,280 Reputation points Microsoft External Staff Moderator

2025-12-19T07:17:22.89+00:00

Hi @Örnvall Andreas

I'm glad it is working now.

If my answer helped you, please mark this as accepted answer.

This will help other people have the similar situation can find this easier.

Warm thanks.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

5 additional answers

Örnvall Andreas 0 Reputation points

2025-12-17T12:53:15.6166667+00:00

It doesnt really say site settings but this is what i can find, i understand that creating a new site can detect if the issue is with the language but that do not really solve the problem, cause if it cant connect it to the original site i cant use that sharepoint list. maybe i need to find another solution to do this list.
Please sign in to rate this answer.
Jayden-P 13,280 Reputation points Microsoft External Staff Moderator

2025-12-17T13:14:38.1+00:00

Please note that our forum is a public platform, and we will modify your question to hide your personal information in the description. Kindly ensure that you hide any personal or organizational information the next time you post an error or other details to protect personal data.

Hi @Örnvall Andreas

Thanks for the image, looks like you are using Team site.

You can click Site information > View all site settings > Look for language settings.

Jayden-P 13,280 Reputation points Microsoft External Staff Moderator

2025-12-17T13:18:14.6333333+00:00

Additionally, what is the format of the date in Swedish?

DD/MM/YYYY or MM/DD/YYYY?

Örnvall Andreas 0 Reputation points

2025-12-18T06:42:05.97+00:00

Thanks now i found it, default language seems to be english.

Date format should be yyyy/mm/dd i guess if i look at the picutre below
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer