Convert string to time format

[Chendoran_M]

Hi. Guys,

How do I change the data of type string in an excel sheet column to time format, i.e: “hh:mm:ss”/“hh:mm”? Can this be implemented in UiPath?

timeData.xlsx (9.6 KB)

ThankYou.

[mahmoud.zaky]

Hi @Chendoran_M,
You can use below solution and its the easy way and more effective however if you do not need to make this solution so you can build data table with date type then write it on excel also below you can take a look in below links

Change Column Type to Date through Assign

@Salem_Ababneh Do one thing. Create one template excel file with pre defined column format and then write data into it. I hope it will help you.

Converting all values in a column to Date format

Hi, If datatable has any data and try to change column type, it will throw exception. So, can you share what you do step by step and expected result? In general, DateTime type doesn’t have format information. It’ll make no sense to convert to dd/MM/yyyy format before input it as DateTime to datatable, i think. Regards,

[RajKumar_DC (RajKumar Durai)]

Hi @Chendoran_M ,

try with “ToShortTimeString”

Thnaks,