time-rounding,and if then statements

amcmillio

New Member
Joined
Oct 8, 2002
Messages
13
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
 
I like that approach better!

If True or False is sufficient,

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

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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!!
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top