Hello everyone,

I had a scheduling problem earlier that I figured how to accomplish, and it works great,except in one regard; it cannot account for working double shifts.

This is the first formula, that looks at the shift that a person works, and inserts it into a second worksheet, putting the time in place.

=VLOOKUP(A84,CHOOSE({1,2},Schedule!$G$1:$G$299,Schedule!$A$1:$A$299),2,FALSE)

The problem comes when someone works two shifts, only the first shift is posted, I need it to display both shifts.

This formula then moves the hours worked into a 3rd worksheet.

=IF(ISNUMBER(SEARCH("0700 - 1530",Interim!H84)),"8-1st",IF(ISNUMBER(SEARCH("1500 - 2330",Interim!H84)),"8-2nd,",IF(ISNUMBER(SEARCH("2300 - 0730",Interim!H84)),"8-3rd,","")))

This then runs into the problem that it only displays the first shift worked, not both, when a person works a double.

Thanks

Dyne