On Oct 25, 1:58*am, " wrote:
I dont know how to make sure the "hh:mm" is time format.
I have not seen any option in the Time Format.

Format, Cells, Number then you will have both "Time" and "Custom"
This maybe won't sound to be very practical method though.
Rather than "hh:mm" value is there any other identifying values on the
other columns on the same rows to be deleted ?
Rgds

Yes you are right..when I open a new Sheet and in put 12:30 the format
shown is in Custom, hh:mm.
The data is in only in Col B....no other values are there.
How did the code worked for you?

Thanks and Regards