Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Formatting Issue
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 "Cathy Landry" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue ??? | Excel Discussion (Misc queries) | |||
formatting issue? | Excel Discussion (Misc queries) | |||
Number formatting issue | Excel Worksheet Functions |