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.
Негізгі бет How to Create Date Difference in SharePoint List Using Calculated Column
No video
Пікірлер: 43