Difficulty in Countif or Sumproduct function

Good afternoon all,

I am trying to do a basic count in a range, however am a little brain fried and its not working.

On attachment, column D is to list all times out of column A and B listing only unique entries (have tried to use Macro with advanced filter however not liking it being an extract).

Column E is to be a count of how many times the break time in Column D appears.

Any help would be appreciated.

Thanks
Darren.

You cannot filter your data because there are empty rows within it.

I would probably go for:

D3: =IF(D2=0,0,LOOKUP(10^10,CHOOSE({1,2},0,SMALL($A$3:$B$28,1+COUNTIF($A$3:$B$28,"<="&N($D2))))))
copied down
Custom Format applied to D3:Dx of: [=0]"";h:mm:ss

E3:
=IF(N($D3),COUNTIF($A$3:$B$28,$D3),"")
copied down

(Note some of your times are unique based on seconds)