Difference between 2 x d/mm/yyyy h:mm cells

[SarahPintal]

Hi guys,

Hope someone can help with this, ive been trying to INT,MOD and format options though cant get it how i want it too..

Basically i have 2 dates formated in d/mm/yyyy h:mm

I.e.
9/04/2010 12:16:31 PM & 20/04/2010 5:45:22 PM


I want to be able work out in 1 cell the time difference between the 2 dates\times... something to the effect of "11days, 5 hours": using the above example

The end result will be to be able to put the data into a pivot table.

[NBVC]

Perhaps

=INT(B1-A1) &" days " &ROUND( MOD(B1-A1,1)*24,0) & " Hours"

this'll round the hours.. if you don't want to, then:

=INT(B1-A1) &" days " &INT( MOD(B1-A1,1)*24,0) & " Hours"

[shg]

=B1-A1, formatted as d"days "h"hours"

[SarahPintal]

Thanks gents,
NBVS's formula did the trick...


I did try the =B1-A1, formatted as d"days "h"hours" before i posted this thread though couldnt get it to work.

In any event, it works

Thanks as always!