How to assign date/time to certain date/time-range

Hello Gentleman,

Somehow, I am rather sure that this is very likely an allegedly easy question, but I failed.
And now after 3-4 hours of "braining" around trying, I ask for support from your expertise here.

Following problem:

I have got a table with a start- and an end-date/time. (Separated by a tab)

Basically, these are information I got from a log file. (Start- / End-date and time of a production machine for one single component)

StartTime EndTime
16/05/2018 10:02:02 16/05/2018 10:03:57
16/05/2018 10:05:05 16/05/2018 10:05:26
16/05/2018 10:12:04 16/05/2018 10:13:53
16/05/2018 10:16:14 16/05/2018 10:16:34
16/05/2018 11:15:05 16/05/2018 11:16:51
16/05/2018 11:25:42 16/05/2018 11:27:31
16/05/2018 11:28:03 16/05/2018 11:28:24
16/05/2018 11:28:45 16/05/2018 11:29:06
16/05/2018 11:32:21 16/05/2018 11:34:12
16/05/2018 11:38:32 16/05/2018 11:38:52
16/05/2018 11:39:20 16/05/2018 11:39:41
16/05/2018 11:39:57 16/05/2018 11:40:18
16/05/2018 11:40:39 16/05/2018 11:40:59
16/05/2018 11:43:00 16/05/2018 11:43:28
16/05/2018 11:44:50 16/05/2018 11:45:11
16/05/2018 12:21:40 16/05/2018 12:23:41
16/05/2018 12:24:10 16/05/2018 12:24:35
16/05/2018 12:27:38 16/05/2018 12:28:03
16/05/2018 12:29:26 16/05/2018 12:29:51
16/05/2018 12:30:56 16/05/2018 12:31:21
16/05/2018 12:32:22 16/05/2018 12:32:47
16/05/2018 12:33:30 16/05/2018 12:33:55
16/05/2018 12:34:28 16/05/2018 12:34:53
16/05/2018 12:35:25 16/05/2018 12:35:51
16/05/2018 12:35:55 16/05/2018 12:36:21
16/05/2018 13:37:47 16/05/2018 13:39:34


I have got one occurrence, which is 16/05/2018 11:38:40, and now I would like to insert a 3rd column in the table which says "Yes", if the occurrence before is within one line Start- and End-date/time; Otherwise "No".

How to automatically implement this?

PS: Please note: I can have several occurrences the same date (16/05/2018), just at different times.

Is that possible?


Many thanks folks.

I am ***** with this too be honest, even though it is rather likely a very simple task.

regards,