Time Difference between two dates

[umayank]

Hi,

I have two dates in column A and B as below

A B

01-01-2012 08:49 01-12-2012 11:35

I want to find out number of days and hours between these two.

Can someone help me please.

Mayank

[royUK]

End Date - Start date formatted as dd hh

[umayank]

I used this =TEXT(B1-A1,"DD:HH") but it gave me 30:02 which is incorrect.

[zbor]

Maybe this: =(B1-A1)/(24+1/240) and format as [hh]:mm