Import Excel Data (hh:mm:ss)

[wueste]

Hello,

i try to import an excel sheet with a 'time' field (format hh:mm:ss, not dateTime) into a string field in Talend.

I don't get the same data.

Source Data: 07:16:09

Talend: 0,30288125

or

Source Data: 02:17:47

Talend: 0,09568800000000001

How can get the right Data (

07:16:09)

in Talend, or what have i to calculate to get the correct result?

Thanks a lot in advance!

[Anonymous]

Hi

In Excel, the cell format should be set to Time. In component, open the Advanced Settings panel, check the 'Convert Date column to string' box.

 

Regards

Shong

[wueste]

Dear Shong,

thanks for your answer. Unfortunately there is no change in the result:

source:

result:any idea?

[Anonymous]

I have made a quick testing and it works on my side. Can you upload a sample excel and for testing?

Regards

Shong

[wueste]

gjeremy,

sorry, but a short question: how to implement? in tmap?

[wueste]

Additional Information: The import file is a .xlsm file! maybe is that the problem?

[wueste]

shong,

attached a sample xlsm.

[wueste]

any ideas?

Thanks!