See my second reply (at 22:17 last night), with a revised solution. The
problem with my first formula was that it was confusing months and minutes,
and I think that Mike fell into the same trap (& again spotted it and
commented to that effect in another message at 22:17). Unfortunately Excel
uses mm as the abbreviation for both months and minutes. :-)
--
David Biddulph

"Raz" wrote in message
...
Thanks David,
this is what Mike gave as well, but my minutes not calculating right, no
matter what date/hours i put, its calculating 1 or 01 minutes. any idea
why?



"David Biddulph" wrote:

=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months,
"&DATEDIF(A1,A2,"md")&" days, "&TEXT(A2-A1,"hh")&" hours,
"&TEXT(A2-A1,"mm")&" minutes, "&TEXT(A2-A1,"ss")&" seconds"
--
David Biddulph

"Raz" wrote in message
...
can anyone tell me how to do this, might be very simple. thanks in
advance

i have two dates/time in this format mm/dd/yyyy hh:mm:ss
17/10/2001 12:35:20
21/12/2009 09:40:00

on another cell I would like the difference between these two dates in
this
format.

8 years, 11 months, 24 days, 00 hours, 20 min, 23 seconds.

or each in a different cell like these:
8 years
11 months
24 days
00 hours
20 min
23 seconds




.