Excel format hours

Hi, I’m having some problems reading an excel file.

The file has this 2 columns when it’s open:
image

The cells have a date format.

When I used the workbook ‘read range’ activity without preserve format, the date came like this ‘02/01/2018’ and the hour like this ‘0.2644328703703’

When I used the workbook ‘read range’ activity with preserve format, the date came fine BUT the hour like this ‘[$-F401]h:mm:ss AM/PM’

How can I get the Hour like in the excel file

@KevinDS

Check as below for your reference
Tutorial : Convert Number to Date Format

Hope this may helps you

Thanks

Hi @KevinDS,

Take a look these 2 . It may help you.

To change the format in the excel.

To handle the date time in the datatable.

Videos :

Regards
Balamurugan.S

1 Like

Hi @KevinDS when u write the excel data in form of string as output can u show the output u got ?