How to Create Date Difference in SharePoint List Using Calculated Column

In this video, I will show you how to Create Date Difference in SharePoint List Using Calculated Column.
You will be able to calculate differences between two (dates) and format the outcome in a way that becomes more readable and fit for purpose.
I did this by creating a Calculated Column in SharePoint List and writing the formula below.
=DATEDIF([Date Logged],DateResolved,"d")&"days "&TEXT([Date Logged]-DateResolved,"hh")&"hrs "&TEXT([Date Logged]-DateResolved,"mm")&"min "&TEXT([Date Logged]-DateResolved,"ss")&"sec"
You can always adapt this formula for your own use.

[@83jann]

Your help was invaluable; I had been searching for a solution for days. Although I encountered many issues with the Spanish language setting, I had to switch languages... Thank you

[@annasraffaele]

Ive been digging through youtube about this exact calculation!! Thank you so much for the detailed but straight forward explanation!

[@robertvandersluis7412]

Thank you - this was hugely helpful on a project I am working on.

[@thebigboiler7627]

This was exactly what I was looking for... thanks for taking the time to upload.

[@technologytrainingatroosev1855]

Excellent. Very clear and I can easily imagine how I can use this for projects. Thank you!

[@shubby271]

Thank you for this formula and the explaination. If the number of days is a certain amount how can it be highlighted?

[@Lifewithnimi998]

Thank you, currently helped me on a project.

[@Aussified]

Thank you. This helped me today.

[@moisescanto9672]

Thank you, great job.

[@venkateshmandlik8861]

Thank you so much 💓

[@Nancyb-art]

Thank you! 👌🏻

[@dominicminton8069]

Thank you. How about if I want to return only the weekdays with sunday as the first day of the week?

[@fanzfanzilla]

Hello, thank you for the video. The calculate field for number days only updates if record changes, in other words if simply refresh the page or load the list, it does not update the calculation. Do you see the same problem? Is there a easy fix?

[@Xoxo-od7ht]

Thanks!

[@missa540]

This has been a huge help. However... The days, hours, and seconds are fine. But for the minutes, it keeps showing as 12mins. Even on your video, all the example entries have 12mins. Why does it keep doing that and how do we fix it?

[@huyfe1347]

Thank you for this. i'm trying to do same thing in my sharepoint list and i'm getting this error : Sorry, something went wrong The formula contains a syntax error or is not supported. TECHNICAL DETAILS Learn more about the syntax for formulas. Troubleshoot issues with Microsoft SharePoint Foundation. Can you help to solve this? Also, how do you convert in sharepoint list column mid working day = 0.5 days? i mean 8:00am to 12:00am = 0.5 days? looking forward to hearing from you

[@srinidhi5471]

Can we convert the UTC time to CST time using calculated share point column

[@DannicaCapistrano]

Hello, hope you can help me. The formula works for the "days", "hours", and "seconds" However, for "minutes" it just outputs 12min whatever date/time difference 0days 00hrs 12min 00sec 6days 19hrs 12min 00sec 2days 04hrs 12min 00sec

[@laurengray6275]

same for me

[@sebmir28]

Same with me. Always 12mins

[@evandrosteindafonseca1169]

😂😂 Same for me, this is happen in video at 8:38...

[@evandrosteindafonseca1169]

Use Integer works better, my formula is portuguese change to your language. =INT([Hora_Fim]-[Hora_Inicio]) & " Dias, " & HORA([Hora_Fim]-[Hora_Inicio]) & " hora, " & MINUTO([Hora_Fim]-[Hora_Inicio]) & " minutos e " & SEGUNDO([Hora_Fim]-[Hora_Inicio]) & " Segundos"

[@ashvinsaini01]

Thank you for sharing such nice video in easiest way. If some the some one of the date is empty how could set some message. like Not Applicable if Time to solve cell is empty.

[@TheOyinbooke]

Thank you very much for your feedback and question. You can write IF condition for this

[@devikumar2609]

Helpful video, but why am I getting 12mins for everything. How to fix it. Thanks

[@AndrewMcnairT]

I just wish it aiutostamped time resolved and time started. Time started =Now() but time closed auto logging date time for duration is a problem

[@jaimieilano8548]

i did a calculated formula for the dates. but the date is showing in mm/dd/yyyy format. is there anyway to change the formula to Month Day, Year format?

[@TheOyinbooke]

Yes. You can set this in the calculated column. Extract Month as Text then add day as DayNo, append a comma, then extract the year. All these can be written as function and the results will be in your desired format

[@kennyfabian2126]

Nice, but how can i make this but excludding weekends

[@___nivi___]

Thank you for explaining it so well. I am confused as this formula worked on some columns only, where the dates are as follows : Start date/time is 12/3/2021 11:00 AM and End date/time is 12/3/2021 1:45 PM it gave me the result as 0 days, 02 hrs, 45 mins. Perfect. But it didn't work when the Start date/time is 11/10/2021 8:00 AM and End date/time is 12/8/2021 10:46 AM. It simply shows as "5". date/time format is MM/DD/YYYY HH:MM AM/PM Can you help me understand what is wrong. The formula I used based on your explanation is : =DATEDIF([End Time],[Start Time],"d")&"days "&TEXT([End Time]-[Start Time],"hh")&"hrs "&TEXT([End Time]-[Start Time],"mm")&"mins "

[@TheOyinbooke]

Can you check your regional settings on the SharePoint site? It might be the one conflicting here

[@otakuchan792]

@@TheOyinbooke it gives me a syntax error

[@samuelopokuacheampong3214]

I'm getting feedback []can not be used here. Please assist

[@pawansaini4776]

Not Working i used same

[@yogibearstie]

What happens if it isn’t resolved yet?

[@TheOyinbooke]

I do not have the idea but I know it will be resolved

[@dannydillon6270]

The math is off here bro. You’re formula is wrong not the machine time configuration. First record should be 7days 1hour 1min Second record: 20days 21 hours 0min Third record: 5days 0hrs 50 minutes

[@dannydillon6270]

Use =INT(End-Start) & “ days, ” & HOUR(End-Start) & “ hours, “ & MINUTE(End-Start) & “ minutes and “ & SECOND(End-Start) & “ Seconds”

[@TheOyinbooke]

Thank you danny for your comment. you are right. I made mistake with the math

[@joydeepdas9931]

@@dannydillon6270 it's not working

[@joydeepdas9931]

@@dannydillon6270 if you can type exact code then it will be better for me.

[@harshininelavai2717]

@@joydeepdas9931 did you find the solution?