rows that need deleting

[LtFass]

Thanks to all who reply to our sometimes obvious questions. This one has me
stumped. I import a converted file from a data recorder that records date,
time, flow rate, pressure, and water level. The format goes like this

A1 - Date
B1 - Time
D1/E1 - Flow
F1/G1 - Pressure
H1/I1 - Water Level

The columns do not have headers. The data is recorded every minute.

Now for the problem: what I would like to do is delete the rows so that the
data is now in five minute intervals. Currently I highlite the rows that I
dont need and then delete them however there are generaly 5k to 100k rows.
Lots of time! Looking for some ideas or help Thanks Cliff

 

[Bob Phillips]

Intervals from what? What will be the base time, 0 hours, or the first time?
And is it to delete any not exactly five minutes from, i.e. maybe delete
everything?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[bpeltzer]

Introduce a helper column J. In j1: =mod(minute(b1),5)). Autofill that
through column J. Then autofilter and in column J, select custom, does not
equal 0. Delete the rows that remain visible, and you'll have your
five-minute samples.

 

[LtFass]

The time base starts at say 09:00:00 and is recorded like this 09:01:00.
09:02:00 ect... what I need to do is remove 09:02:00 - 09:04:00 leaving only
09:01:00 then 09:05:00 and so on I hope this helps

 

[LtFass]

Thank you that worked very well all I needed to do was add one more ( between
the = and the Mod. Thanks again