SharePoint Calculated Column to Display Duration Between Two Dates in Hour-Minute

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 blog I am going to explain how we can achieve this.

Step 1: Create a Share point List having two column of Date and Time Type as below:
 
 
 
Step 2: Now create a Lookup column BookedDuration(This Column will automatically calculate duration between the above Column
 
 
The Result will be Shown as below:-