SOLVED

How to calculate the duration between two date columns in a List?

%3CLINGO-SUB%20id%3D%22lingo-sub-1419888%22%20slang%3D%22en-US%22%3EHow%20to%20calculate%20the%20duration%20between%20two%20date%20columns%20in%20a%20List%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419888%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ECalculation%20and%20display%20of%20duration%20of%20a%20proces%2C%20calculated%20as%20difference%20of%20two%20column%20in%20SP%20list%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20want%20to%20store%20the%20difference%20in%20days%20in%20column%20C%20between%20two%20columns%20A%20and%20B%20of%20a%20List%20in%20Sharepoint.%20%26nbsp%3BBoth%20A%20and%20B%20are%20Date%20column.%20Column%20C%20is%20a%20calculated%20column.%20I%20work%20in%20NL%2C%20using%20Netherlands%20as%20locale.%20Field%20A%20and%20B%20correctly%20display%20date%2FTime%20in%20format%20of%20Netherlands.%20The%20formula%20in%20column%20C%20(which%20is%20A-B)%20yield%20a%20result%2C%20the%20delta%20in%20hours%20is%20correct%2C%20but%20it%20shows%20a%20date%20in%20the%2018th%20century.%20How%20can%20I%20create%20the%20correct%20number%20of%20days%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1419888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1421825%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20the%20duration%20between%20two%20date%20columns%20in%20a%20List%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421825%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156612%22%20target%3D%22_blank%22%3E%40Bernd%20Kroon%3C%2FA%3E%26nbsp%3BYou%20can%20use%20the%20following%20approach%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1590610121059.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194852i8A9965AF31400FEA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1590610121059.png%22%20alt%3D%22Vikram_Samal_0-1590610121059.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20will%20be%20the%20way%20column%20will%20be%20defined%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_1-1590610219403.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194853i6B9F39FC259ED215%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_1-1590610219403.png%22%20alt%3D%22Vikram_Samal_1-1590610219403.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20hope%20this%20gives%20you%20some%20directions%20to%20think.%20Mark%20the%20response%20appropriately%20if%20it%20help%20you%20finding%20the%20solution.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EVik%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422777%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20the%20duration%20between%20two%20date%20columns%20in%20a%20List%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422777%22%20slang%3D%22en-US%22%3EThank%20you%2C%20Vik!%3C%2FLINGO-BODY%3E
Occasional Contributor

Calculation and display of duration of a proces, calculated as difference of two column in SP list

I want to store the difference in days in column C between two columns A and B of a List in Sharepoint.  Both A and B are Date column. Column C is a calculated column. I work in NL, using Netherlands as locale. Field A and B correctly display date/Time in format of Netherlands. The formula in column C (which is A-B) yield a result, the delta in hours is correct, but it shows a date in the 18th century. How can I create the correct number of days?

2 Replies
Best Response confirmed by Bernd Kroon (Occasional Contributor)
Solution

@Bernd Kroon You can use the following approach 

Vikram_Samal_0-1590610121059.png

This will be the way column will be defined:

Vikram_Samal_1-1590610219403.png

I hope this gives you some directions to think. Mark the response appropriately if it help you finding the solution.

 

Thanks,

Vik