Thread: Averaging Times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mashuganah Mashuganah is offline
external usenet poster
 
Posts: 27
Default Averaging Times

I need to average a list of minutes and seconds in mm:[ss] format (the only
format that would display them properly):
0:35
0:40
0:39
0:42
0:26

Excel 2003 SP2 is giving 1:00 rather than 00:36. How do I get Excel to do
this correctly?