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
Bookmarks