View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy Landry Cathy Landry is offline
external usenet poster
 
Posts: 37
Default Number Formatting Issue

Hello,

I download a monthly report that contains all of our departments incoming
call volume. One column is the duration formatted as 0:01:09. When I try to
do a sum I get a zero. I've tried different formatting and text to column
and have to resort to copying that column into Word then doing a copy/paste
special as text back into Excel for the sum function to work properly. Any
suggestions?

Thank you!!
Cathy