Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |