Merging two columns (Date and Hours)

Question

Hi&nbsp;I have two columns that I would like to combine:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hour01-01-2019 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101-01-2019 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;I would like to get the following result:01-01-2019 01:00:0001-01-2019 02:00:00Best regards

stvsurf · Accepted Answer

You can use the following:&nbsp;[Date]&nbsp;+ #duration(0,Number.From([Hour]),0,0))

Forum Discussion

Merging two columns (Date and Hours)

1 Reply

Related content

Merge Column

Merge duplicates data in columns

Hour Calculation

Merge columns keep null

MERGE QUERIES