So I am given times of the day and I need to match the shift with the time so I was wondering if there was a macro that would make this easy. For example, between 07:00 and 15:00 is shift 1 and 15:00 to 23:00 is shift two and the other period is shift 3. I'm sure that there is a loop for this but it needs to continue until there are no more excel lines on the sheet (usually about 3500 lines). If anyone could point in the right direction on how to orchestrate this loop, it would be very much appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!