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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"TBA" wrote in message
...
I have tried a number of the responses posted- sorry i can't seem to get
it
right!
I want to calculate the number of days and hours between two date time
values
e.g.

cell A1 start: 17/01/2006 16:12
cell A2 finish: 25/01/2006 10:00
cell A3 answer: 7 days 18 hrs

and is it possible to leave cells A1 and A2 in dd:mm:yy hh:mm format
rather
than 'general'?

thanks for your help-