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

    Using a pivot table to add minuets

    I have a download which automatically gives hours and minutes. I wanted to get the number of minutes per specified day that was spent on certain activities. Is it possible to summarize using a PIVOT TABLE . I will include a sample of the downloaded file.

    Thanks.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Add the activities to the row label (like you have the date added) and format the minutes as [m] to give elapsed minutes

    Steve

Posting Permissions

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