patrick_oneal
New Member
- Joined
- Nov 14, 2016
- Messages
- 12
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.
<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.
<tbody>
</tbody>
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>