Filtered Data Formula

[KristenLehman]

Hello,

I'm trying to copy filtered data to a new worksheet using a formula. I can't figure out a formula that will only copy the filtered data, leaving out unwanted cells. The data that will be in this worksheet will change, I think the only thing that will remain the same is a time frame between 0.09:00:00 to 0.09:01:39.

example
0:09:00:00
0:09:00:01
0:09:00:02
0:09:00:03
...
...
Down to
0:09:01:39

I need a formula that will do this so that I don't have to do it manually, I have to much data.

 

[Momentman]

If it means maybe filtering based on being greater than equal to that start time and less than or equal to end time, then something like this with O365

=FILTER($A$1:$A$8,($A$1:$A$8>="0:09:00:00")*($A$1:$A$8<="0:09:01:39"))