LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JPP JPP is offline
Member
 
Posts: 35
Post Average Time Not Calculating

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Average Time Eán[_2_] Excel Worksheet Functions 3 March 2nd 09 04:18 PM
Calculating an average Maggie Excel Worksheet Functions 1 August 22nd 08 03:50 AM
Calculating Average ub Excel Discussion (Misc queries) 2 July 16th 08 05:14 PM
Calculating Average Graham Excel Worksheet Functions 1 July 2nd 08 04:40 PM
Calculating the average Andy_Trow Excel Discussion (Misc queries) 3 July 27th 07 02:15 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"