Of course if the OP wants to input the data in time format such as 10:01 in
A2, then Excel can do the job of splitting it into your suggested separate
components, so the years in C2 would be =HOUR(A2), and the months in D2
would be =MINUTE(A2).
--
David Biddulph

"Sandy Mann" wrote in message
...
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