time-rounding,and if then statements

[amcmillio]

I have a spreadsheet that has 2000 points of time listed. The time is in 22 minute incremants. I only want the cells with the time that are closest to the hour. It is never the same. How can I delete the cells that are not closest to the hour without doing it manually? I have 40 other spreadsheets to do the same with. Please help me to find a way to stop doing it manually and get rid of my headache. Is there a formula I can use? I am not use to using time in formulas.

Example:
11:06 (I would keep)
11:28 (I would delete)
11:50 (I would keep)
12:12 (I would delete)
12:34 (I would delete)
12:56 (I would keep)
1:18 (I would delete)
Etc...
This message was edited by amcmillio on 2002-10-09 13:25

 

[Dave Patton]

I like that approach better!

If True or False is sufficient,

=OR(MINUTE(A1)<=11,MINUTE(A1)>=49)

 

[amcmillio]

I was out of the office yesterday so I am just getting these new responses. Let me check them out and I will keep you posted.

Thank you!!

 

[amcmillio]

YOU ALL ARE ****AWESOME****!!!!!!!!!!

It works!

Thank you! Thank you! Thank you!!!!