rows that need deleting
 

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

rows that need deleting
 

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)


"LtFass" wrote in message
...
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

rows that need deleting
 

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" wrote:

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

rows that need deleting
 

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



"Bob Phillips" wrote:

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)


"LtFass" wrote in message
...
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

rows that need deleting
 

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

"bpeltzer" wrote:

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" wrote:

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