Using a time format to represent presents enormous, if not insurmountable
problems. I would suggest that you divide the years and months in two
cells. Thus the chronological age may be in C2& D2 as 12 and 7 respectively
meaning an age of 12 years and 7 months. The reading age may be in F2 & G2
as 11 & 6. The formula to work out the difference in ages is:

=DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)),MAX(DATE (C2,D2,1),DATE(F2,G2,1)),"y")&"
Years
"&DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)),MAX(DAT E(C2,D2,1),DATE(F2,G2,1)),"ym")&"
Months"&IF(DATE(F2,G2,1)DATE(C2,D2,1)," In Advance"," Behind")

If you want to prevent it showing 1Years 1 Months instead of 1 Year 1 Month
then use:

=DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)),MAX(DATE (C2,D2,1),DATE(F2,G2,1)),"y")&"
Year"&IF(DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)), MAX(DATE(C2,D2,1),DATE(F2,G2,1)),"y")<1,"s
","
")&DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)),MAX(DA TE(C2,D2,1),DATE(F2,G2,1)),"ym")&"
Month"&IF(DATEDIF(MIN(DATE(C2,D2,1),DATE(F2,G2,1)) ,MAX(DATE(C2,D2,1),DATE(F2,G2,1)),"ym")<1,"s
"," ")&IF(DATE(F2,G2,1)DATE(C2,D2,1)," In Advance"," Behind")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jo" wrote in message
...
I have two columns: chronilogical age and reading age. I need to calculate
the difference between these ages. Age displayed as eg. 10:01 (10 years
and
1 month) actual format is hh:mm.
Please can someone tell me the correct formula?
Thanks