Hi there,
I'm trying to figure out a formula to show the difference between two date and times.
The dates and times are displayed in a pivot table and filtered to show the data from another sheet.
What I'm trying to show is I have data that records the amounts of calls that my specific team take, and I'd like to show the difference in a date and time format in between the repeat calls that come back into the team.
I've used some basic formulas but they don't seem to show the day and/or time in between the calls.
I'd basically like to achieve a view that looks similar to this:

So the data in the pivot shows one call that came in 9/07/2014 10:15 and another at 11/07/2014 10:15.
The way I'd ultimately like it to display is that there was 2 days in between these two calls or else in a hour format (eg. 48hrs) would work too.

Any help would be greatly appreciated.

Thank you