Results 1 to 7 of 7

How to calculate movement

Threaded View

Jeanette_W How to calculate movement 09-11-2013, 09:02 PM
NickyC Re: How to calculate movement 09-11-2013, 11:01 PM
Jeanette_W Re: How to calculate movement 09-11-2013, 11:09 PM
NickyC Re: How to calculate movement 09-11-2013, 11:47 PM
NickyC Re: How to calculate movement 09-11-2013, 11:25 PM
Jeanette_W Re: How to calculate movement 09-11-2013, 11:32 PM
Jeanette_W Re: How to calculate movement 09-12-2013, 01:37 AM
  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to calculate movement

    I have this spreadsheet (about 25000 rows) too many to do manually.
    There are 3 columns - dd/mm/yyyy - hh:mm:ss - Direction
    In the direction column there are 2 options BA and AB.. These are traffic counters..

    So I would like some help with calculating the time it took for a car to drive over these counters.. When the time is more than 20 seconds, the car went into a yard.
    However as you can see from the attached spreadsheet it isn't a simple formula. Well for me anyway.

    So can someone help me with calculating the time, bearing in mind the different directions.

    Thanks heaps
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I calculate rank movement?
    By speedbird168 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2013, 07:34 AM
  2. cell movement
    By stevesunfold in forum Excel General
    Replies: 2
    Last Post: 10-01-2008, 12:59 PM
  3. change the tab movement
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2008, 01:52 PM
  4. Cursor Movement
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2006, 07:55 PM
  5. [SOLVED] movement
    By Ross in forum Excel General
    Replies: 6
    Last Post: 09-25-2005, 09:05 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