Hi

I have condition that I want only those rows which have time between 8p-10p for Monday to Saturday and between 7p-10p for only sunday. If you look at j10 you will understand that I have taken the same as it has 8.15p means 15 mintues are there after 8p and day is R=Thursday. I have attached sample file for your reference. Column D and E has raw data where as J and K has formatted data. Is any macro or a function can be used? Any help would me much appriciated.

Thanks