@Harish_pavuluri - Here you go
TimeFilter_HP_Updated.zip (281.8 KB)
The reason why my initial code was not working, in your new sheet Column “Time” is formatted as Time. When you print this you will get as shown below
0.79888888888889
To read this value you have to use the below code first…this will print the date as 19:10:24
datetime.FromOADate(cdbl(currentrow("Time").ToString)).ToString("HH:mm:ss")
Write Line Output
Without Conversion ==>0.79888888888889 After Conversion == > 19:10:24 – 1395898
678 filtered result were written in the Filtered sheet.
Hope this helps…