Merging two columns (Date and Hours)

[Anonymous]

Hi

I have two columns that I would like to combine:

             Date                                       Hour

01-01-2019 00:00:00                 1

01-01-2019 00:00:00                 2

I would like to get the following result:

01-01-2019 01:00:00
01-01-2019 02:00:00

Best regards

[stvsurf · Accepted solution]

You can use the following:

[Date] + #duration(0,Number.From([Hour]),0,0))