How create new date column from date and hours

[WaikatoNorthHead]

I would like to combine a date column (dd/MM/yyyy) and a separate hours (123) column into a new date format column, that comprise of both the date the hour of the day (dd/MM/yyyy HH:mm)

[calamari]

G'day @WaikatoNorthHead 

Using a Compute Column you can achieve what you're after this way by concatenating the two columns into a single one, and then using the datevalue function:

DATEVALUE(CONCATENATE(@Posting Date (no time)@, " " ,@Posting Time@), "dd/MM/yyyy HHmmss" ) 

Given the data:

The result would be:

Hope that helps (try out creating a filtergram on "datetime" columns if you haven't already)!

Cheers,

Calamari