Hi,

Just to clarify what you said in regards to being able to use
'1 Days, 2 Hrs, 23 Min' the same as '01 Days, 02 Hrs, 23 Min'...
The formula would have to be greatly modified to take into
account those entries which have a single digit (1) as opposed to two digits
(01)?


If you still insist in a formula solution:

=INT(AVERAGE(MMULT(SUBSTITUTE(MID(A1:A2,SEARCH({"d ays","hr","min"},
A1)-3,3),",","")/{1,24,1440},{1;1;1})))& "_Days,_" &
TEXT(AVERAGE(MMULT(SUBSTITUTE(MID(A1:A2,SEARCH({"d ays","hr","min"},
A1)-3,3),",","")/{1,24,1440},{1;1;1})),"hh""_Hr,_""mm""_Min""")

Regards,

Daniel M.