Discrepancy in the data

KNIME Analytics Platform
1

Hi Team,

I have calculated the difference between two dates using “datetime&difference node”.
I am able to see the output duration as below in it.
image

but after exporting to the Excel sheet the data is displaying as below.
image

Could you please suggest me what changes do i need to make or any other transformations.

Thanks,
Subramanyam Kinthada

2

Look at these nodes

and

2 Likes
3

Hi @izaychik63 ,

Thanks a lot for the suggestion, The extract Duration Fields + column combiner helps me to achieve the required output.

1 Like
4

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