Hi,
I have this sort of Data from row 1 to row 9999
A B C
200 22.95 09:28:47 AM
300 56.67 09:29:32 AM
200 12.75 09:30:06 AM
100 75.97 09:32:47 AM
200 22.95 09:49:00 AM
etc...
I want to find a way the create a VBA procedure that would delete all the rows that the time in column C is over 09:30:00 AM
I have tried to convert the time into a number and then if formula to see if the number is higher than 0.3958333 but it doesn't work
any other ideas?
I have this sort of Data from row 1 to row 9999
A B C
200 22.95 09:28:47 AM
300 56.67 09:29:32 AM
200 12.75 09:30:06 AM
100 75.97 09:32:47 AM
200 22.95 09:49:00 AM
etc...
I want to find a way the create a VBA procedure that would delete all the rows that the time in column C is over 09:30:00 AM
I have tried to convert the time into a number and then if formula to see if the number is higher than 0.3958333 but it doesn't work
any other ideas?