Number Formatting Issue

[Cathy Landry]

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

 

[Fred Smith]

Sounds like your cell is text, not a time (at least to Excel). To convert to
a time:
-- Enter 0 in an unused cell
-- Copy that cell
-- Highlight your duration cells
-- Right-click, choose, Paste Special... Add
-- You may have to format the cells after this.

Regards,
Fred