How to filter excel Column on time

excel

#1

I have Excel data like
Name company Time received
xyz abc 15:00:00
xyz1 abc1 15:00:04

i have to filter on the basis on time received

I am passing query dt.select("[Time receieved]>=‘15:00:00’") but it throws an error that ‘>=’ cannot be applied to system.string and system.double.


#2

Try doing it via Filter Data Table activity!


#3

you can try like below

assign variable A as int with row value

then use
dt.select(A>=“15:00:00”)