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
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
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"
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?
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
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.
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?
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?
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
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 "
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
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
Ive been digging through youtube about this exact calculation!! Thank you so much for the detailed but straight forward explanation!
This was exactly what I was looking for... thanks for taking the time to upload.
Thank you, currently helped me on a project.
Thank you. This helped me today.
Thank you for this formula and the explaination. If the number of days is a certain amount how can it be highlighted?
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
same for me
Same with me. Always 12mins
😂😂 Same for me, this is happen in video at 8:38...
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"
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?
Thank you, great job.
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
Thank you! 👌🏻
Thank you so much 💓
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.
Thank you very much for your feedback and question.
You can write IF condition for this
Thank you. How about if I want to return only the weekdays with sunday as the first day of the week?
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?
Helpful video, but why am I getting 12mins for everything. How to fix it. Thanks
Thanks!
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?
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
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
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 "
Can you check your regional settings on the SharePoint site? It might be the one conflicting here
@@TheOyinbooke it gives me a syntax error
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
Use =INT(End-Start) & “ days, ” & HOUR(End-Start) & “ hours, “ & MINUTE(End-Start) & “ minutes and “ & SECOND(End-Start) & “ Seconds”
Thank you danny for your comment. you are right. I made mistake with the math
@@dannydillon6270 it's not working
@@dannydillon6270 if you can type exact code then it will be better for me.
@@joydeepdas9931 did you find the solution?
Not Working i used same
Thank you - this was hugely helpful on a project I am working on.
I'm getting feedback []can not be used here. Please assist
Can we convert the UTC time to CST time using calculated share point column
Nice, but how can i make this but excludding weekends
Excellent. Very clear and I can easily imagine how I can use this for projects. Thank you!
What happens if it isn’t resolved yet?
I do not have the idea but I know it will be resolved