My data set has Name, Assignment, Start Date, Start Time, End Date and End Time as well as a field that has the calculated hours worked. Under the Assignment field there are 5 categories. I need a formula that will give me: If assignment #1 AND assignment #2 were covered each day during the same 4 hour period. One more piece of information -- there is no set start time and end time so I would need to find a 4 hour overlap.
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!