Help with deleting rows according to time value

Hi all ,

I am struck with a problem.. I have a sheet which generate a data of machines which runned over a day ,, I dont want the data which ran on mid night means 12.00 am to morning 8.00 am
i want to delete those datas.

please help

Thanks in advance

excel_time.xlsx

Try this code on your test data first -

Please Login or Register  to view this content.

Put the code in a standard module.

Hi,
Thank you so much its working but its giving an error atlast

Run time error "13"
type mismatch


one more thing can u add one more condition which is " delte all the lines after 9pm " if possible . thank you so much rep added