I'm in search of a formula to determine time gaps between tasks based upon work dates. For instance, an employee worked on 9/18, and he/she performed multiple tasks throughout the day. Lets assume the task start and end times were 9am-1pm, 12pm-3pm, and 4pm to 6pm. I need a formula or workflow that will first identify the job date, analyze the start/end times, and locate the 1 hour gap between 3pm and 4pm. The data is setup as follows.