Days and hours between 2 datetime fields in PowerPivot

[TheCman81]

These dates are UK format dd/mm/yyyy

I've googled the $h!t out of this and can't find what I need.

I'm looking to create a calculated column that shows Days and hours between 2 datetime fields.

So for example I have Open Date and Closed Date:

Open: 12/11/2018 19:10:43 Closed: 12/11/2018 21:11:15 Result: 0 Days 2 Hours
Open: 01/11/2018 13:01:15 Closed: 09/11/2018 17:55:00 Result: 12 Days 4 Hours
Open: 05/11/2018 23:59:59 Closed: 06/11/2018 01:22:12 Result: 0 Days 1 Hours

Then the measure I will use in my pivot table would show the average days and hours in the same field (if this is possible), if it's not possible, then the days and hour part could be split into separate fields.

Thanks

 

[Matt Allington]

Assuming they are formatted as date time. Just write [closed] - [open] and format as decimal number.