Selecting rows after time intervals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

I have some data which is collected at different times. I need to find the rows who are registered between 1:00:00 and 1:05:00 and copy them to a new worksheet. How do I do that????


Regards
dSb
 
----- dSb wrote: ----

Hello

I have some data which is collected at different times. I need to find the rows who are registered between 1:00:00 and 1:05:00 and copy them to a new worksheet. How do I do that???

**********

You could apply a filter (Data/filter/Autofilter) to the column the click on the drop down box and select custom. Here you make it equal to 1:00:00 and less than or equal to 1:05:00. This should then filter down your rows


Regard
dSb
 
Back
Top