Join 24 hour column to date column

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!