Dates and Times With Match Formula

[patrick_oneal]

Hello All,

I am trying to work a formula that checks if times listed in a grid match times in another page. I've been trying to work with MATCH, but I feel I'm on the wrong train of thought.

The first page is the data with times I need to mine. I cannot edit this page because it comes exported from another source.

It has a list of names and times they have entered appointments.

Name	Start Time	End Time
Name #1	1 Jan 2018 13:30	1 Jan 2018 14:00
Name #2	1 Jan 2018 09:00	1 Jan 2018 09:45

<tbody>
</tbody>

The next has a list of all names and all times in a day, and I need it to cross check and just see if they have an appointment at the date an time on the other page.

Name	1 Jan 2018 01:00	1 Jan 2018 02:00	1 Jan 2018 03:00	1 Jan 2018 04:00
Name #1
Name #2
Name #3

<tbody>
</tbody>

 

[BiocideJ]

I'm not sure how to respond to your request. The times (as you've shown) aren't always going to line up (e.g. a start time at 13:30 where as the summary only lists hourly times)
What should the expected output look like? Just an X in the cell if any part of the meeting falls within the hour?

Additionally, what about meetings that span multiple hours?