Hi All,
I have a spreadsheet laid out like below (headers as columns):
<tbody>
</tbody>
What I need to do is be able to do is something like below where I enter three classes and for each class check whether there is a time overlap with any of the other classes and, ideally although not completely necessary, identify which class it overlaps with - I'm not sure how this would work where there is overlap with multiple clashes.
<tbody>
</tbody>
Any help/guidance you can offer would be much appreciated! Please let me know if you need me to provide you with any further information so that you can assist.
I have a spreadsheet laid out like below (headers as columns):
Class | Start | End | Category |
Mod01 | 01-May-2019 10:00 | 01-May-2019 12:00 | Sem |
Mod02 | 01-May-2019 11:00 | 01-May-2019 13:00 | Tut |
Mod02 | 02-May-2019 09:00 | 02-May-2019 10:00 | Lab |
Mod03 | 03-May-2019 10:00 | 03-May-2019 11:00 | Sem |
<tbody>
</tbody>
What I need to do is be able to do is something like below where I enter three classes and for each class check whether there is a time overlap with any of the other classes and, ideally although not completely necessary, identify which class it overlaps with - I'm not sure how this would work where there is overlap with multiple clashes.
Class | Start | End | Category | Choice | Overlap? |
Mod01 | 01-May-2019 10:00 | 01-May-2019 12:00 | Sem | Mod01 | Mod02 |
Mod02 | 01-May-2019 11:00 | 01-May-2019 13:00 | Tut | Mod02 | Mod01 |
Mod02 | 02-May-2019 09:00 | 02-May-2019 10:00 | Lab | Mod03 | OK |
Mod03 | 03-May-2019 10:00 | 03-May-2019 11:00 | Sem |
<tbody>
</tbody>
Any help/guidance you can offer would be much appreciated! Please let me know if you need me to provide you with any further information so that you can assist.