Identifying Time Overlaps/Clashes

[GG58975]

Hi All,

I have a spreadsheet laid out like below (headers as columns):

[TABLE="width: 500"]
<tbody>[TR]
[TD]Class[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]Mod01[/TD]
[TD]01-May-2019 10:00[/TD]
[TD]01-May-2019 12:00[/TD]
[TD]Sem[/TD]
[/TR]
[TR]
[TD]Mod02[/TD]
[TD]01-May-2019 11:00[/TD]
[TD]01-May-2019 13:00[/TD]
[TD]Tut[/TD]
[/TR]
[TR]
[TD]Mod02[/TD]
[TD]02-May-2019 09:00[/TD]
[TD]02-May-2019 10:00[/TD]
[TD]Lab[/TD]
[/TR]
[TR]
[TD]Mod03[/TD]
[TD]03-May-2019 10:00[/TD]
[TD]03-May-2019 11:00[/TD]
[TD]Sem[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Class[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Category[/TD]
[TD]Choice[/TD]
[TD]Overlap?[/TD]
[/TR]
[TR]
[TD]Mod01[/TD]
[TD]01-May-2019 10:00[/TD]
[TD]01-May-2019 12:00[/TD]
[TD]Sem[/TD]
[TD]Mod01
[/TD]
[TD]Mod02[/TD]
[/TR]
[TR]
[TD]Mod02[/TD]
[TD]01-May-2019 11:00[/TD]
[TD]01-May-2019 13:00[/TD]
[TD]Tut[/TD]
[TD]Mod02[/TD]
[TD]Mod01[/TD]
[/TR]
[TR]
[TD]Mod02[/TD]
[TD]02-May-2019 09:00[/TD]
[TD]02-May-2019 10:00[/TD]
[TD]Lab[/TD]
[TD]Mod03[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]Mod03[/TD]
[TD]03-May-2019 10:00[/TD]
[TD]03-May-2019 11:00[/TD]
[TD]Sem

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.