Would like to retrieve data from range H, where any duration has negative number. Please bear in mind that I actually have over 10k rows and this is just an example.
try like this:
=FILTER(A:B; B:B<0)