I have a list of people that are working particular shifts which are set up
in four to five hour increments. Some people are working consecutive shifts
(working eight/nine hours in a day). I am trying to show each person's
schedule with beginning and end times using VLOOKUP. It is working just fine
if the people only work one shift per day. The multiple shift people only
have their first shifts display. I would like to LOOKUP based upon the
person's name giving the first shift's start time and the second shift's end
time and haven't found a good combination of functions to use. Any
suggestions?