How to Create Date Difference in SharePoint List Using Calculated Column
34.8 هزار بار بازدید -
3 سال پیش
-
In this video, I will
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.
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.
3 سال پیش
در تاریخ 1400/03/10 منتشر شده
است.
34,889
بـار بازدید شده