BrendanDixon
Board Regular
- Joined
- Mar 7, 2010
- Messages
- 174
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All
I am trying to make a formula that will look at the date and time in cell J16 and the look at the table below and show what is the current shift e.g. A,B or C. RD stands for Rest Day i.e. the person is off work.
<tbody>
</tbody>
I am trying to make a formula that will look at the date and time in cell J16 and the look at the table below and show what is the current shift e.g. A,B or C. RD stands for Rest Day i.e. the person is off work.
DAY | Shift A | Shift B | Shift C |
SUN | 06:00 - 18:00 | RD | 18:00 - 06:00 |
MON | 06:00 - 14:00 | 22:00 - 06:00 | 14:00 - 22:00 |
TUE | 06:00 - 18:00 | RD | 18:00 - 06:00 |
WED | 18:00 - 06:00 | 06:00 - 18:00 | RD |
THU | 18:00 - 06:00 | 06:00 - 18:00 | RD |
FRI | RD | 18:00 - 06:00 | 06:00 - 18:00 |
SAT | RD | 18:00 - 06:00 | 06:00 - 18:00 |
<tbody>
</tbody>