+ Reply to Thread
Results 1 to 2 of 2

Creating time ordered table from pivot

  1. #1
    Registered User
    Join Date
    01-30-2006
    Posts
    12

    Creating time ordered table from pivot

    Hi

    I am trying to monitor time taken for jobs to be completed in certain areas. My data consists of records for each step of a job with a time stamp and its location (there are many steps for each job). Using a pivot I can sort on location, I have the jobs as rows then can get the start time and finish time as two columns referring to the time stamp of each job by using the min and max in the value options.
    What I would like is to be able to produce a table where I have time start to time finish for each job in the top row (in chronological order) with the job number underneath. Is this possible?

    Thanks in advance.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Creating time ordered table from pivot

    It may help us in our efforts to help you if you could upload a small sample of your data as well as a manually produced sample of the expected output.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating time sliced Pivot data in Excel based on two time fields
    By swinster in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-06-2016, 08:22 AM
  2. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  3. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  4. Replies: 5
    Last Post: 08-22-2013, 09:56 AM
  5. [SOLVED] run time error creating pivot table and group dates by year and month
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2013, 07:25 AM
  6. Need help creating a pivot table for a time sheet
    By redneck9407 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2013, 04:56 PM
  7. [SOLVED] Runt time error when creating pivot table
    By csh8428 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 03:21 PM

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