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.

>