How to catch overlapping times across multiple days in Excel

[hutch458]

Is there a way to catch overlapping times across multiple days? I need a way to ensure appointment times are not overlapping.

Additionally, would it also be possible to differentiate this kind of data between multiple staff? Or would it just have to be ran individually.

Thanks in advance for any help you can offer!

 

[awoohaw]

what version of excel do you use?

please update your profile so the forum will always see this when you make posts.

The reason is that some versions of excel have features that are not available in others (Excel 365 v Excel 2019, for example).

Thanks in advance.

 

[hutch458]

what version of excel do you use?

please update your profile so the forum will always see this when you make posts.

The reason is that some versions of excel have features that are not available in others (Excel 365 v Excel 2019, for example).

Thanks in advance.

Updated, I use 365

 

[hutch458]

I've managed to find a way to catch overlapping times across multiple days by using adding a table, a FILTER statement, then a SUMPRODUCT statement. But now I'm struggling to have it filter not only by date but by staff.