Results 1 to 3 of 3

Macros:need to count specific no of objects at a fixed time interval say 5 minutes

Threaded View

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Macros:need to count specific no of objects at a fixed time interval say 5 minutes

    Please help me solve this problem.I hv a excel file in which there are 4 columns namely Vehicle,Start time,End Time,Speed.I want result to come in a way like.
    No. of vehicles types crossed along with their average speed at a 5 minute interval.like

    Start Time End Time LCV Two wheeler Car small buses car big mini bus 3 auto
    vol||Avg Speed vol||Avg Speed

    57319.42 62319.42 3 speed/no of entries n so on...


    I am also attaching file.
    Attached Files Attached Files
    Last edited by mady94; 04-15-2015 at 03:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Solve for X?
    By mitch22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2014, 12:17 PM
  2. ****, How to solve this?
    By mwoerd in forum Excel General
    Replies: 2
    Last Post: 04-19-2012, 04:20 AM
  3. try to solve this
    By sun_ilkumar in forum Excel General
    Replies: 1
    Last Post: 12-14-2009, 06:36 AM
  4. need help to solve this
    By klaengur in forum Excel General
    Replies: 2
    Last Post: 05-09-2006, 04:09 AM
  5. How to solve?
    By Lee Tow in forum Excel General
    Replies: 2
    Last Post: 06-24-2005, 08:05 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