Hey guys, i've got a pivot table which spits out the following.

So eg Cell B1 will equal 15/11/2016 6:50:28AM and cell C1 will equal 15/11/2016 3:28:12PM. I need a formula i can use or use in a calculated field to get the difference between the 2 cells in hours. So eg 8 hours 38 min or whatever it is.

I tried B1 - C1 which came up with 0.35 which i can't get to equate to a time period.


Cheers