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 this article I am going to explain how we can retrieve difference between two dates in hour and minute by using calculated column in SharePoint 2013.
Follow below steps:
Step-1: Create a Share point List having two column of Date and Time Type as below:


SharePoint Calculated column to display duration between two dates in Hour-Minute
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
SharePoint 2013 Calculated column to display duration between two dates in Hour-Minute
The Result will be Shown as below:-
SharePoint 2016 Calculated column to display duration between two dates in Hour-Minute
SharePoint 2016 Calculated column to display duration between two dates in Hour-Minute
Conclusion:
In this article I have explained how to calculate duration between two dates in SharePoint List
Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials: