+ Reply to Thread
Results 1 to 3 of 3

Find row where time value falls between start and end time values

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Find row where time value falls between start and end time values

    Hello, I am trying to find the best solution for a problem involving time spans. I have two excel spreadsheets, one containing a list of start and end times for various activities, and the other showing a timecard for an employee as well as the respective billing codes they are in along with a start and end time for each of these timecard activities. The goal is to find a way to determine what billing code an employee was in for each activity by checking the start and end times for each activity to find what row in the timecard they fall between the start and end times for; and referencing the billing code for that row. I have attached a spreadsheet containing example data.Time-Activity Problem.xlsx

    Thanks

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Find row where time value falls between start and end time values

    Pl see attached file with formula in E column of "Activities" sheet.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Find row where time value falls between start and end time values

    Excellent, that works just as I had hoped. Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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