SharePoint Calculated Column to display duration between two dates in Hour-Minute

Recently, I was working on Project where There was a requirement to display the duration in Hour and Minute between two dates in SharePoint. In this article, I am going to explain how to retrieve the difference between two dates in hour and minute by using a calculated column in SharePoint 2013.

Follow the below steps:
Step-1: Create a SharePoint List having two columns of Date and Time Type as below:

SharePoint Calculated Column to display duration between two dates in Hour-Minute

Step-2: Now create a Lookup column BookedDuration(This Column will automatically calculate duration between the above Column).

SharePoint 2013 Calculated Column to display duration between two dates in Hour-Minute

The Result will be Shown as below:

SharePoint online calculated Column to display duration between two dates in Hour-Minute

You may like following SharePoint calculated column tutorials:

In this article, I have explained how to calculate the duration between two dates in SharePoint List using the SharePoint calculated column.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>