Read a excel that contains column type time

I need to read a excel (DT) and write in another excel .Second row in excel contains time values ( example: 2:17:00 AM)
But when read the excel DT is storing the value as 1/0/1900 2:17:00 AM.What step i need to do so only 2:17:00 AM is stored in DT

Please help.

can you share the input data and expected output
@tharani.natarajan

Hi @tharani.natarajan

Yeah if we mention the time its getting the random date so if you need only time you can try this

you can try this Xaml

Xaml : - Read a excel that contains column type time.zip (2.0 KB)

outPut :-

image

let me know its working or not for you