There is more data removed from the workbook attached for simplicity sake, but I can't figure out how to have column D look at the same row and determine if column A, for that row, falls within the Time Range table and places the appropriate shift in column D. So for example, D4 would look at A4 then see what range (F2:G4) that falls between and returns the corresponding cell from column H.
I tried doing an index, but I was running into an issue with 3rd shift just kept continuing. I think it is because the date in the background of the cell changed.
These times on this sheet will be adjusted often, but consecutive. I need the sheet to display what shift each start time falls on.
I also tried converting time to a decimal and that also just kept continually added up and didn't reset.
Any help would greatly be appreciated.
Thanks
Bookmarks