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

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:-