Hi All,
I need some help with a formula. In Column A I have the persons name, Column B i have the start time of a persons shift. In column C i have the end time of that shift. The shifts can be any back to back combination of 5 minutes from 7am to 8pm so there are a total of 156 possible shifts in a given day. I have created a list which names each 5 minute interval also from 1 to 156
What i want to happen is that if a shift is entered but it contradicts a shift already there then it shows up as an error. Can have this as a conditional format of a cell or an error message in Column D whichever is the easiest.
So for example:
<tbody>
</tbody>
thanks in advance
I need some help with a formula. In Column A I have the persons name, Column B i have the start time of a persons shift. In column C i have the end time of that shift. The shifts can be any back to back combination of 5 minutes from 7am to 8pm so there are a total of 156 possible shifts in a given day. I have created a list which names each 5 minute interval also from 1 to 156
What i want to happen is that if a shift is entered but it contradicts a shift already there then it shows up as an error. Can have this as a conditional format of a cell or an error message in Column D whichever is the easiest.
So for example:
Name | Shift Start | Shift End | Error Check | Date |
John Jones | 7am | 10am | Shift coindcides with another shift | 14/04/16 |
John Jones | 10am | 11am | 14/04/16 | |
John Jones | 8am | 9am | Shift coindcides with another shift | 14/04/16 |
<tbody>
</tbody>
thanks in advance