monty12321
New Member
- Joined
- Aug 27, 2019
- Messages
- 6
Good afternoon,
I was wondering if you could use your help on excel. I have a excel spreadsheet which automatically imports room bookings data from the Microsoft word forms. However, sometimes we get clashes with requests overlapping each other. I would like this to be highlighted automatically instead of manually checking it. Below is the sample:
<tbody>
</tbody>
As you can see there are several overlaps/conflicts, but I must highlight this manually. Hence, is there a way to get excel to do this automatically. I understand this could be done by formula “Sumproduct” but, I was unable to get it to work thus I looked around and stumbled upon this https://www.mrexcel.com/forum/excel-questions/429758-find-time-overlaps.html and found the other formula(s) but i am still unable to get it working. The formula still gives the "False" value despite the overlaps/conflicts.
Therefore, any help would be much appreciated.
Thanks
Monty
I was wondering if you could use your help on excel. I have a excel spreadsheet which automatically imports room bookings data from the Microsoft word forms. However, sometimes we get clashes with requests overlapping each other. I would like this to be highlighted automatically instead of manually checking it. Below is the sample:
Course Type | Date | Start and End Time |
Workshop | 08/12/2019 | 09:00-13:00 |
Workshop | 08/12/2019 | 09:00-14:00 |
Training | 15/08/2019 | 09:00-16:00 |
Workshop | 16/08/2019 | 09:00-17:00 |
Training | 17/08/2019 | 09:00-17:00 |
Training | 18/08/2019 | 09:00-18:00 |
Workshop | 18/08/2020 | 15:00-18:00 |
Training | 20/08/2019 | 09:00-13:00 |
Workshop | 22/08/2019 | 08:00-15:00 |
Training | 22/08/2019 | 08:00-11:00 |
Workshop | 08/12/2019 | 09:00-13:00 |
<tbody>
</tbody>
As you can see there are several overlaps/conflicts, but I must highlight this manually. Hence, is there a way to get excel to do this automatically. I understand this could be done by formula “Sumproduct” but, I was unable to get it to work thus I looked around and stumbled upon this https://www.mrexcel.com/forum/excel-questions/429758-find-time-overlaps.html and found the other formula(s) but i am still unable to get it working. The formula still gives the "False" value despite the overlaps/conflicts.
Therefore, any help would be much appreciated.
Thanks
Monty