Get Time from Excel column in hh:mm:ss format

[Ping_Pong]

Hi there,

I am new to uipath, Can anyone help me with get Time data from excel which the data is not reading as expected

I want to match with a time and
I have to get the data from the in hh:mm:ss format from the excel.

How can I achieve this ?

Please suggest any valuable Ideas
Thank you.

[Vinit_Mhatre (BotBuilder)]

Hey, @Ping_Pong
You can try this for your reference
Test.xaml (10.7 KB)
Input.xlsx (8.4 KB)
Hope this will work for you
Thanks,
Vinit Mhatre

[Yoichi]

Hi,

The following expression might help you.

DateTime.FromOADate(Double.Parse(Str_Excel_Time.ToString)).ToString("hh:mm:ss")

Regards,

[THIRU_NANI (NaNi)]

Hi!

Can we try like this

Cdate(str_Excel_Time).ToString(“HH:mm:ss”)

Reference: DateTime Format In C#

Regards,
NaNi