I need help, I received link references from a corporate spreadsheet with
time format 13:30 (representing mm:ss). I am trying to get at SUM and AVERAGE
of these cells and having a hard time getting it right. I did try to have
output format as [m]:ss and it is coming out incorrectly. If I have to
convert these to h:mm:ss is there a way to make to conversion happen
automatically.

Example:

20:12
5:31
9:47
8:45
8:27
7:25
20:21
17:46
13:01
22:17

SUM these to format [m]:ss will give me 15212:00
SUM these to format mm:mm will give me 32:00
AVERAGE these to format 13:30 will give me 1:21

Can someone explain what is Excel doing here and possible offer me a
solution for AVERAGE these times.

Thanks,

Kha