+ Reply to Thread
Results 1 to 3 of 3

How to Calculate Transit Time In a Report With Different Dates, Times and Locations

  1. 08-30-2013, 01:02 PM #1
    kesibrian
    kesibrian is offline
    Registered User
    Join Date
    08-30-2013
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to Calculate Transit Time In a Report With Different Dates, Times and Locations

    Hi,

    I need to calculate transit times in an excel spreadsheet. The data is pulled from a web site as a xls file. This report includes transit times for train shipments. The shipments go through multiple carriers ( up, BNSF, NS...) and so there's multiple transit time points that need to be calculated. The problem is that not all shipments go through the same route and so a simple subtraction from one cell to another will not work for all shipments. I'm currently working down the report, reguring out shipment by shipment. The report is VERY long and I'm pretty sure that there's an easier way to do this. Could anyone help me with this?


    Thanks very much
    Rgds
    Kenny
    Reply With QuoteRegister To Reply
  2. 08-30-2013, 05:01 PM #2
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: How to Calculate Transit Time In a Report With Different Dates, Times and Locations

    Hello and welcome.
    Your workbook will handy here.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  3. 08-31-2013, 11:22 AM #3
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to Calculate Transit Time In a Report With Different Dates, Times and Locations

    You could set up codes for each transit point and combine them to form a route code. For example, if a shipment went from point A to point L and had to go through transit points D and J on the way the code would be ADJL and if the shipment went directly the code would be AL. This could be set up in a table with the appropriate transit times pre-calculated and entered into the column right of the codes. Then all that would be required is a lookup of the code for the shipment and the transit time would be presented to you.

    It would take time to set this up but once established would be very quick to yield results.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to calculate transit times?
    By AndyL66 in forum Excel General
    Replies: 4
    Last Post: 05-21-2010, 09:55 AM
  2. Calculate Date/Time between two dates and times
    By LJ76 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2010, 05:34 PM
  3. [SOLVED] How do I calculate time between 2 dates/times subtracting the time over weekends?
    By bugmenot in forum Excel General
    Replies: 4
    Last Post: 01-25-2009, 11:25 AM
  4. calculate elapsed time between dates and times
    By Jenna in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2006, 12:45 PM
  5. Formula to calculate elapsed time between certain dates and times
    By Stadinx in forum Excel General
    Replies: 6
    Last Post: 03-25-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1