View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default SUM or AVERAGE of mm:ss

Yes, if you do Format | Cells | Number (tab) then it shows Time with
13:30 - this means hours and minutes. Click on 13:30:55 (two down on
the list) and you should see your first value change to 20:12:00, in
which case it is formatted as I suggested and you can follow my
suggestions to rectify it.

Pete