MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Average time for a column of cell entries in mins:secs is calculated how ?

Posted by Mark on December 15, 2001 11:14 AM

I know this is a simple problem but I am just starting out with Excel and I can't figure out how to do this seemingly simple task. Any help would be appreciated.

eg. 3:20 , 2:45 , 5:15

So, if I have a column of cells with these values in them how do I generate an average time.

Posted by Aladin Akyurek on December 15, 2001 11:22 AM

Mark --

Just average them:


where A1:A100 houses time entries.


Posted by Mark on December 15, 2001 12:23 PM

thx Aladin but I am unable to create cells that display mm:ss correctly

For some strange reason using custom-->mm:ss and then typing in a time value does not display properly. See my question I posted above this one.