Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2005
    Thanked 0 Times in 0 Posts

    pivot table using time ( hrs & min) (xp & 2003)

    I want to creat a pivot table by date for each person for the amount of time for each date. I would also like to create a graph by person for each date. Since the numbers represent time, it is not working as expected. I am attaching the worksheet containing the data I want to use for the basis of the pivot table and chart.



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: pivot table using time ( hrs & min) (xp & 2003)

    There are some rows containing 'September 18, 2006' as text instead of a date; you should correct those.
    You can set the number format for the Time field in the pivot table (double click the field in the Layout dialog, or double click the gray button for this field in the pivot table itself. Use [h]:mm for cumulative time.

    See attached version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts