Excel format hours

[balupad14 (Balamurugan)]

Hi @KevinDS,

Take a look these 2 . It may help you.

To change the format in the excel.

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

To handle the date time in the datatable.

UiPath Marketplace - BalaReva Easy Data Table Activities

Dear all, I have developed a new activity called “DateTime ParseTo Datatable”. Convert the object/string data type to dateTime datatype in Data. And also has the solution Solution to manage the excel DateTime in DataTable. [image] Sample :DateConversion.zip (35.5 KB) [UiPath convert column datatype to datetime in DataTable] Thank you Balamurugan.S

Videos :

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Balamurugan.S

UiPath convert column datatype to datetime in DataTable