How to Create Date Difference in SharePoint List Using Calculated Column

Описание к видео How to Create Date Difference in SharePoint List Using Calculated Column

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.

Комментарии

Информация по комментариям в разработке