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)
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)!