cmanlongat
New Member
- Joined
- May 10, 2016
- Messages
- 21
Shift Clock In Times/Type | |||||||||||||||
Schedule | Day = 5a - 1P | ||||||||||||||
Shift | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Swing = 2P -11P | |||||||
Swing | OFF | OFF | 2P - 10P | 2P - 10P | 2P - 10P | 2P - 10P | 2P - 10P | Grave = 1A - 4A | |||||||
Grave | 1A - 9A | 1A - 9A | 1A - 9A | 1A - 9A | 1A - 9A | OFF | OFF | ||||||||
Day | 10A - 6P | 10A - 6P | 10A - 6P | OFF | OFF | 10A - 6P | 10A - 6P |
<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>
</tbody>
Hi All,
I have a spreadsheet just like this where Shift is in A4 and Monday is in C4 as well.
I need a formula that will give me either "Day", "Swing", or "Grave" under Shift based on the employees schedule on the right side. Is there any way that this could be accomplished? I tried searching for specific text in a cell, but it is skewed whenever "OFF" is stated. Also, since there are SO many different shift times, I would individually have to search a new schedule time in a new IF formula -- it's messy.
If any of you could provide insight on how to do this, I'd appreciat it immensley. Thank you all!