Convert string to time format

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)


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 :slight_smile:

1 Like

Hi @Chendoran_M ,

try with “ToShortTimeString”


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.