With the format that have, enter the times like this...
0:15:09
15 minutes and 9 seconds... it will appear like this 15:09

"VeronicaO" wrote:

Please help. I am entering minutes and seconds...i.e. 34:10 into a
worksheet to be charted. One column is number of calls, the other column is
minutes and seconds. At the bottom of the column I need an AVERAGE of the
total minutes and seconds. I've tried to format the cells for mm:ss but it
seems to convert the time to hh;mm;ss? Any suggestions.....Please help I'm
going crazy trying to figure this out.