Assuming years in A2:A30 and months in B2:B30
MAX
=====================================
=SUMPRODUCT(MAX((A2:A30)+((B2:B30)/12)))
will give for example 5.83
=MAX(A2:A30)&" Yr(s) &
"&(12*MOD(SUMPRODUCT(MAX((A2:A30)+((B2:B30)/12))),1))&" Mths"
will give for example 5 Yrs & 10 Mths
MIN
=====================================
=SUMPRODUCT(MIN((A2:A30)+((B2:B30)/12)))
will give for example 1.25
=MIN(A2:A30)&" Yr(s) &
"&(12*MOD(SUMPRODUCT(MIN((A2:A30)+((B2:B30)/12))),1))&" Mths"
will give for example 1 Yr(s) & 3 Mths
Assumes no blanks in your data.
AVG
=====================================
=AVERAGE(A2:A30)+(AVERAGE(B2:B30)/12)
will give for example 3.52
=FLOOR(AVERAGE(A2:A30)+(AVERAGE(B2:B30)/12),1)&" Yr(s) &
"&TEXT((12*MOD(AVERAGE(A2:A30)+(AVERAGE(B2:B30)/12),1)),"0.0")&" Mths)"
will give for example 3 Yrs & 6.2 Mths