View Single Post
  #1   Report Post  
VeronicaO
 
Posts: n/a
Default Formatting minutes and seconds to calculate a total average

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.