How to use IF condition to choose minutes.

[KKMB]

I have list of time (elapse time) in cells where I want to choose and hide only the rows with 30 minutes.

Eg:
0:00
0:30
1:00
1:30
2:00
2:30
3:00
3:30
4:00
4:30
5:00
5:30
6:00
6:30
7:00
7:30
8:00
8:30
9:00
9:30
10:00


Thanks in advance

[:) Sixthsense :)]

Is it needs to be performed only on 0:30 or something with this 1:30, 2:30, 4:30.

Please provide some more details about column reference and if possible attach a sample workbook for better understanding.

[Moo the Dog]

Not sure what you mean by "hide" them, but in another column you could try this formula, which should hide the time ending in 30 minutes. results will be decimals, but you can format that to h:mm...

With your times starting in A1, put this in B1 and fill down your list of times:

=IF(MINUTE(A1)=30,"",A1)

- Moo

[KKMB]

Thanks for u both

I have attached a worksheet for your reference.

I will get Date, Time and RTD values
I want to plot a graph for RTD values at every one hour ( 1.00, 2.00, 3.00 ……)
I need to hide the rows with log hr of 30 minutes.
How can I use excel functions / command to highligh / hide / delete log hours with 30 minutes ?

[:) Sixthsense :)]

Try the below code in standard module and Press Alt+F8 to run the macro

Please Login or Register  to view this content.

[KKMB]

Thanks for your suggesstion Sixthsense . Its working fine