Filter Data Table using the Time Value?

[winningvish (Vishnu Vardhan)]

Ok May i know what is the format of that column?

[suma123 (suma)]

Actually i’ve the changed the excel format into another format (For Eg: Press ctrl+L). It is in .xls format.

[winningvish (Vishnu Vardhan)]

That I have understood Suma.
I would like to column format is General or any thing else, like below

[suma123 (suma)]

Yeah it is general

[winningvish (Vishnu Vardhan)]

Can you please try selecting the property Preserve Format option in the Read Range activity. Run the workflow and please let me know

[suma123 (suma)]

Yes winningvish, I just tried with that but still got the same error

[winningvish (Vishnu Vardhan)]

And also disable the for each row activity please.

[suma123 (suma)]

It’s working now.
Thank you so much vishnu

[winningvish (Vishnu Vardhan)]

Great to know Suma.

Happy Automation

Regards
Vishnu

[suma123 (suma)]

Hello Vishnu, How can I filter the range in between 08:00:00 - 09:00:00.
Can u please help to solve this problem
Thanks in advance.

[winningvish (Vishnu Vardhan)]

Maybe filter data table activity works

In Filter wizard

Use
column Name > 08:00:00 AND
Column Name < 09:00:00

[suma123 (suma)]

Thanks alot Vishnu, its working