+ Reply to Thread
Results 1 to 2 of 2

Adding Time:a pivot table to add the total amount of each

  1. #1
    Wesley Accellent
    Guest

    Adding Time:a pivot table to add the total amount of each

    I have a colum where the amount of time required to make a particular part is
    listed in seconds (this is the result of a formula subratcting the start time
    from the end time). I have a pivot table to add the total amount of each
    type of part time and the total time required to make the parts. I can not
    get the seconds and minutes to add up to realistic numbers.

    How can I add minutes and seconds and get a usable number?

  2. #2
    Gary''s Student
    Guest

    re: Adding Time:a pivot table to add the total amount of each

    The pivot table may be working. First try formatting the pivot results as
    [mm]:ss
    --
    Gary's Student


    "Wesley Accellent" wrote:

    > I have a colum where the amount of time required to make a particular part is
    > listed in seconds (this is the result of a formula subratcting the start time
    > from the end time). I have a pivot table to add the total amount of each
    > type of part time and the total time required to make the parts. I can not
    > get the seconds and minutes to add up to realistic numbers.
    >
    > How can I add minutes and seconds and get a usable number?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1