[TABLE="width: 1064"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]16/02/2018 12:46
[/TD]
[TD]16/02/2018 13:32
[/TD]
[TD]16/02/2018 13:54
[/TD]
[TD="align: right"]01:08:27
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]16/02/2018 13:23
[/TD]
[TD]16/02/2018 13:58
[/TD]
[TD]16/02/2018 14:00
[/TD]
[TD="align: right"]00:37:09
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]19/02/2018 14:35
[/TD]
[TD]20/02/2018 10:07
[/TD]
[TD]20/02/2018 10:33
[/TD]
[TD="align: right"]50:58:14
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 11:02
[/TD]
[TD]20/02/2018 11:08
[/TD]
[TD]20/02/2018 13:00
[/TD]
[TD]20/02/2018 13:13
[/TD]
[TD="align: right"]02:05:03
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 10:56
[/TD]
[TD]20/02/2018 12:22
[/TD]
[TD]20/02/2018 13:13
[/TD]
[TD]20/02/2018 13:19
[/TD]
[TD="align: right"]00:57:47
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 13:11
[/TD]
[TD]20/02/2018 13:20
[/TD]
[TD]20/02/2018 15:10
[/TD]
[TD]20/02/2018 15:53
[/TD]
[TD="align: right"]88:33:51
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Int
[/TD]
[TD="align: right"]20/02/2018 14:18
[/TD]
[TD]20/02/2018 15:45
[/TD]
[TD]21/02/2018 08:31
[/TD]
[TD]21/02/2018 08:34
[/TD]
[TD="align: right"]01:49:12
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]problem statement
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]for every february date in column F count how many times in column G are 48 hours or greater
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]COLUMN H is a helper column that flags the rows that satisfy the conditions
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]01/02/2018 00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]28/02/2018 00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48:00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
thank you so much for your time on this! It has become a lot more complicated in the mean time!!
I need to scan column f for February, then column b for enquiry type and then column g for enquiry's that have taken longer than 48 hours. is that even possible? so eventually ill have a neat little table telling me how many Ext, Comp and Int took over 48 hours...
[TABLE="width: 830"]
<tbody>[TR]
[TD]TA[/TD]
[TD]Type of Enquiry (Internal, External)[/TD]
[TD]Date In[/TD]
[TD]Date Start[/TD]
[TD]Date Out[/TD]
[TD]Turnaround
(hh:mm:ss)[/TD]
[TD]Site [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]15/12/2017 00:00[/TD]
[TD]28/12/2017 12:05[/TD]
[TD]28/12/2017 12:30[/TD]
[TD]68:00:41[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:31[/TD]
[TD]28/12/2017 12:35[/TD]
[TD]23:05:26[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:35[/TD]
[TD]28/12/2017 12:39[/TD]
[TD]23:09:14[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:39[/TD]
[TD]28/12/2017 12:42[/TD]
[TD]23:12:53[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:43[/TD]
[TD]28/12/2017 12:46[/TD]
[TD]23:16:42[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]13/12/2017 00:00[/TD]
[TD]28/12/2017 12:48[/TD]
[TD]28/12/2017 12:51[/TD]
[TD]86:21:41[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]13/12/2017 00:00[/TD]
[TD]28/12/2017 12:54[/TD]
[TD]28/12/2017 12:59[/TD]
[TD]86:29:03[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]11/12/2017 00:00[/TD]
[TD]28/12/2017 12:59[/TD]
[TD]28/12/2017 13:03[/TD]
[TD]104:33:48[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD="align: right"]06/11/2017 00:00[/TD]
[TD]28/12/2017 13:17[/TD]
[TD]28/12/2017 13:22[/TD]
[TD]329:52:15[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD="align: right"]13/11/2017 00:00[/TD]
[TD]28/12/2017 13:23[/TD]
[TD]28/12/2017 13:26[/TD]
[TD]284:56:05[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col span="3"><col><col></colgroup>[/TABLE]