is it possible?
Example data below. Basically, I want to build a formula that says on x date (01/02/2018), is there a value during the 7:00/8:00/9:00 hour? I've tried wildcards and lookups, but I think the format of the time is the biggest issue. I can get results if I enter as '7:32 vs 7:32 AM but I'm working with over 3000 lines and really don't want to manually enter all of the times. HELP!
<colgroup><col></colgroup><tbody>
</tbody>
Example data below. Basically, I want to build a formula that says on x date (01/02/2018), is there a value during the 7:00/8:00/9:00 hour? I've tried wildcards and lookups, but I think the format of the time is the biggest issue. I can get results if I enter as '7:32 vs 7:32 AM but I'm working with over 3000 lines and really don't want to manually enter all of the times. HELP!
1/2/2018 7:32 |
1/2/2018 7:41 |
1/2/2018 7:52 |
1/2/2018 7:53 |
1/2/2018 8:16 |
1/2/2018 8:29 |
1/2/2018 8:33 |
1/2/2018 8:34 |
<colgroup><col></colgroup><tbody>
</tbody>