software

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?

Hi!

Do the shifts span past midnight like 10:00 PM - 6:00 AM ?

If not then you could use something like this:

For the earliest start time:

=MIN(IF(A1:A10=quot;some_namequot;,B1:B10))

For the latest end time:

=MAX(IF(A1:A10=quot;some_namequot;,B1:B10))

You can replace quot;some_namequot; with a cell reference.

These are array formulas and must be entered using the key combination of
CTRL,SHIFT,ENTER.

Biff

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

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Do the shifts span past midnight like 10:00 PM - 6:00 AM ?
gt;
gt; If not then you could use something like this:
gt;
gt; For the earliest start time:
gt;
gt; =MIN(IF(A1:A10=quot;some_namequot;,B1:B10))
gt;
gt; For the latest end time:
gt;
gt; =MAX(IF(A1:A10=quot;some_namequot;,B1:B10))
gt;
gt; You can replace quot;some_namequot; with a cell reference.
gt;
gt; These are array formulas and must be entered using the key combination of
gt; CTRL,SHIFT,ENTER.
gt;
gt; Biff
gt;
gt; quot;Indy_Ballquot; gt; wrote in message
gt; ...
gt; gt;I have a list of people that are working particular shifts which are set up
gt; gt; in four to five hour increments. Some people are working consecutive
gt; gt; shifts
gt; gt; (working eight/nine hours in a day). I am trying to show each person's
gt; gt; schedule with beginning and end times using VLOOKUP. It is working just
gt; gt; fine
gt; gt; if the people only work one shift per day. The multiple shift people only
gt; gt; have their first shifts display. I would like to LOOKUP based upon the
gt; gt; person's name giving the first shift's start time and the second shift's
gt; gt; end
gt; gt; time and haven't found a good combination of functions to use. Any
gt; gt; suggestions?
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Indy_Ballquot; gt; wrote in message
news
gt; Biff -
gt; That worked marvelously.
gt; Thanks
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Do the shifts span past midnight like 10:00 PM - 6:00 AM ?
gt;gt;
gt;gt; If not then you could use something like this:
gt;gt;
gt;gt; For the earliest start time:
gt;gt;
gt;gt; =MIN(IF(A1:A10=quot;some_namequot;,B1:B10))
gt;gt;
gt;gt; For the latest end time:
gt;gt;
gt;gt; =MAX(IF(A1:A10=quot;some_namequot;,B1:B10))
gt;gt;
gt;gt; You can replace quot;some_namequot; with a cell reference.
gt;gt;
gt;gt; These are array formulas and must be entered using the key combination of
gt;gt; CTRL,SHIFT,ENTER.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Indy_Ballquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a list of people that are working particular shifts which are set
gt;gt; gt;up
gt;gt; gt; in four to five hour increments. Some people are working consecutive
gt;gt; gt; shifts
gt;gt; gt; (working eight/nine hours in a day). I am trying to show each person's
gt;gt; gt; schedule with beginning and end times using VLOOKUP. It is working
gt;gt; gt; just
gt;gt; gt; fine
gt;gt; gt; if the people only work one shift per day. The multiple shift people
gt;gt; gt; only
gt;gt; gt; have their first shifts display. I would like to LOOKUP based upon the
gt;gt; gt; person's name giving the first shift's start time and the second
gt;gt; gt; shift's
gt;gt; gt; end
gt;gt; gt; time and haven't found a good combination of functions to use. Any
gt;gt; gt; suggestions?
gt;gt;
gt;gt;
gt;gt;