+ Reply to Thread
Results 1 to 6 of 6

Duration of off street Parked Vehicles

  1. #1
    Registered User
    Join Date
    10-04-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Duration of off street Parked Vehicles

    Hello,

    I have made a sample data and results for my query which best explains my question.

    I need to find the duration of the vehicles off street (parking lot) vehicles parked. I see there are discrepancies in my data but have to use this data and come up with the result.

    Any help would be great.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Duration of off street Parked Vehicles

    I see multiple entries of each vehicle.. What should happen in this case?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    10-04-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Duration of off street Parked Vehicles

    Thank you for your quick response.

    Multiple entries are allowed but the ideal situation is there should be as many exits of a particulat vehicle no. as there are entries not more, not less. As vehicles can come multiple times to park on same day. So the result for multiple vehicles should be:
    1. If No. of entries of a particular vehicle no. is exactly equal to exit:
    Result: "OK" -we shall get the duration

    2. If No. of entries of a particular vehicle no. are more than exit -
    result : "No exit"
    Explaination: case for vehicle no. KAL333P

    3. If No. of Entries of a particular vehicle no. is less than exit -
    result: "multiple exits"
    Explaination: case for vehicle no. KAG824K

    Hope I explained it well.
    If there is any query pls post.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Duration of off street Parked Vehicles

    Please see the file attached.. Is this what you want?

    Sample data.xlsx

  5. #5
    Registered User
    Join Date
    10-04-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Duration of off street Parked Vehicles

    Thanks a lot bro. This is what I require.

  6. #6
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Duration of off street Parked Vehicles

    Glad it worked! Please mark the thread as Solved..

+ 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. [SOLVED] Duration of Parked Vehicles
    By keshav4075 in forum Excel General
    Replies: 5
    Last Post: 03-17-2015, 02:05 PM
  2. [SOLVED] Trying to separate street number and street name into columns
    By greenmat in forum Excel General
    Replies: 7
    Last Post: 07-27-2012, 04:24 PM
  3. separate street address and street number
    By iwanttoplaywii in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-24-2011, 09:45 PM
  4. how do I convert cell 'Street,#' to '# Street' these are addresse
    By Closing hyperlinked wookbooks upon exit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2006, 06:23 AM
  5. How do I sort a column of street number/street name by the stree.
    By JHoleman1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2005, 09:06 PM

Tags for this Thread

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