+ Reply to Thread
Results 1 to 3 of 3

Formula for working out top X of a date time difference

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Bracknell
    MS-Off Ver
    Excel 2010
    Posts
    86

    Formula for working out top X of a date time difference

    Good Afternoon,

    I was wondering if someone could please assist me with an issue that I have?

    Issue:
    1. The attached file shows an example extract of a data extract that has thousands of lines. See the Data Tab.
    2. What I need is some time that has passed between two dates in a DDHHMM format
    3. What I then need is the top 50 of each of the times (or the longest time past)
    4. The column headers will be: WO Number | Contractor Name | Time Calculation – see the various Report tabs
    5. The calculations in the Data tab are between the following columns.
    a. Difference between Column Z and Column AC
    b. Difference between Column AC and Column AD
    c. Difference between Column AD and Column AE
    d. Difference between Column AE and Column AF
    6. Is it possible to show the top 50 only in time?

    This is a really tricky one and not sure it is possible easily but I sure hope so. This report is forming a part of a larger report and all other formulas are already present so I am hoping to keep the file size quite small. The aim is to then hand this over to someone else to just print on a monthly basis depending on the data that gets added with minimum input.

    Thank you so much,
    Andrew
    Attached Files Attached Files
    Last edited by amasson; 02-24-2014 at 05:26 PM.

  2. #2
    Registered User
    Join Date
    01-15-2013
    Location
    Bracknell
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Formula for working out top X of a date time difference

    Hi Folks,

    Has anyone been able to think of a solution to this conundrum?

    Much appreciated.
    Andrew

  3. #3
    Registered User
    Join Date
    01-15-2013
    Location
    Bracknell
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Formula for working out top X of a date time difference

    Good Morning,
    I guess this one is not possible but if anyone has some direction then please do let me know.

    Take care,
    Andrew

+ 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. Replies: 1
    Last Post: 09-13-2012, 05:50 AM
  2. Replies: 0
    Last Post: 09-13-2012, 05:28 AM
  3. Replies: 3
    Last Post: 12-23-2010, 04:46 PM
  4. Time Difference Still Not Working
    By bwhizz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2007, 03:14 PM
  5. Calculating Time difference not working
    By Mindtrap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-10-2007, 11:17 AM

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