Join 24 hour column to date column

[Anonymous]

Hi, 

I'd like to join a date column (mm/dd/yyy) with a time (hour) column. The time column "Delivery Hour", as seen below, is a whole number 1 through 24. 

I've read that I can simply add these columns after converting "Delivery Hour" to a "time" type, but when I convert this, each number, 1 through 24 turns into 12:00 am. 

Here is the sample data,

Thanks in advance! 

Delivery Date	Delivery Hour
01/03/2019	1
01/03/2019	2
01/03/2019	3
01/03/2019	4
01/03/2019	6
01/03/2019	7
01/03/2019	8
01/03/2019	9
01/03/2019	10
01/03/2019	11
01/03/2019	12
01/03/2019	13
01/03/2019	14

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula and format it as dd/mm/yyyy hh:mm

=Data[Delivery Date]+TIME(Data[Delivery Hour],0,0)

Hope this helps.