Formula to filter out multiple time ranges

[tonywatsonhelp]

Hi Everyone,

I have a bit of a problem hope someone can help
I have a list of times from 00:00:00 to 23:59:00
I want to create a filtered list excluding the multiple times I select

so in Column D25:D1464 I have my list of times
in cell AJ27 start date
aJ28 end date
aj 31 exclusion start
AL32 Exclusion end

So I want to make a list like this

create a list in column F starting at F25
the first time is start time (i.e 11:00:00)
and the list goes down to end time,
now the first problem is I want to be able to select the end time so it can be the next day so 03:00:00 for example (but will never go past the start Time)
any ideas how i could do this/
thanks
Tony

 

[Skybluekid]

Firstly, are you able to post some data and expected results. Secondly, the list of times is that by minute or hour?