Hi to all,
I am getting error like “Assign: Conversion from string “” to type ‘Double’ is not valid.” after reading the excel sheet.
this is the logic
(From r In Dttime.AsEnumerable
Where datetime.FromOADate(CDbl(r(“Time”).ToString)).ToString(“HH:mm:ss”) > “06:00:00” And datetime.FromOADate(CDbl(r(“Time”).ToString)).ToString(“HH:mm:ss”) < “11:59:59”
Select r).CopyToDataTable
It should filter the data with in the given time.