We help IT Professionals succeed at work.

Working with Time in Pivot Tables/Functions

559 Views
Last Modified: 2012-08-13
I export data from a phone system daily.  This tells me how many total phone calls were made and total talk time.  I use a formula to figure out average talk time each day.  I want to create a pivot table using this data to summarize weekly total calls and total talk time as well as average talk time and I also want to be able to summarize this for monthly and quarterly data.  I can't figure out how to work with time when using formulas and pivot tables.  Can anyone help?  I have attached a small sample of the data that I intend to use.  I know pivot table basics.  My problem is working with time. Time-Source-Data-Example.xlsx
Comment
Watch Question

Grand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Awesome!  That is exactly what I was looking for.  Thanks!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.