I have 55437 rows of data.

![Screenshot of first few rows of data](https://i.stack.imgur.com/kRe3M.png)

My goal is to filter out only the flow rate between 1pm and 7pm. As you can see from the time intervals each minute has 3 readings, so manually doing it is going to take a long time. Is there a way of using VBA to delete all the rows not in the specified time period?

Thank you.

This is what the top answer's solution looks like after I have changed 0.541666667 to 0.54166666:

![This is what the top answer's solution looks like after I have changed 0.541666667 to 0.54166666](https://i.stack.imgur.com/DHgGS.png)