On Oct 25, 12:54*am, " wrote:
James' code worked for me OK.
I only had to make sure "hh:mm" is time format not custom.
Rgds

Hi
The data on which I was trying the code is copy pasted from the
Internet.
I tried James' code on a new sheet and it worked for two conditions.
Rows with hh:mm format were not deleted.
I dont know how to make sure the "hh:mm" is time format.
I have not seen any option in the Time Format.
Only option available is in Custom.

Any clues!

Thanks
PS: Also would you guide me how to convert the data copy pasted from
the Internet to a format which will be recognised by the Macro.