While reading excel data for time base it is throwing error

[prasath17 (Guru)]

@Harish_pavuluri - Based on the excel sheet you provided in the below post, this should work without any error…If your column has Null or Space value it will throw an error which you have to handle this before filtering the data

In between time data filter

@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 …

screenshot of the filtered sheet with 678 rows out of 1878 rows in the sheet1