Quote:
Originally Posted by JPP
I have a simple AVERAGE function, it averages the call time for all agents. I am not having troubles with the function itself though. The problem is when I copy and paste the information into the workbook, the information shows, but it does not "average" the time. I have to double click on each cell individually, after I double click on every cell with a time in it, it then averages the call time. Why does this not work right after pasting the information in? I have also tried doing a "paste special" but that did not work either. Thanks in advance!
|
When you say you tried "paste special" do you mean "paste special / values"?
If so then it will work on the proviso the cells you're pasting into are formatted the same as the others that do work.
Give that a try, and if still no luck, post an example workbook (without confidential information) on here and someone will happily help out.
S.