Forum Discussion
Solved
How to calculate the duration between two date columns in a List?
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 Sharepo...
Bernd Kroon You can use the following approach
This will be the way column will be defined:
I hope this gives you some directions to think. Mark the response appropriately if it help you finding the solution.
Thanks,
Vik
Bernd Kroon You can use the following approach
This will be the way column will be defined:
I hope this gives you some directions to think. Mark the response appropriately if it help you finding the solution.
Thanks,
Vik
I did this using UK time/dates
Start 22/1/2024 19:00 and end 22/1/2024 20:10
The delta is shown as "30" using your formula. I would like to calculate hours and tried swapping the "D" to both "h" and "H" and it says "#VALUE!"
I tried it as number and single line of text but still no avail
Can you help