In excel 2007 I have 2 columns that I need to combine into one. A is Date in yyyymmdd format, while B is time in hhmm format, though zeros are not prefixed before 10:00! I need to somehow combine them to read mm/dd/yyyy hh:mm (ie January 1st 2012 12:34)

The nature of the time coming without always 4 digits and without a colon is driving me nuts trying to format it all though!

Here is a sample of my input and problem:

20120101 20
20120101 53
20120101 153
20120101 206
20120101 235
20120101 253

So all of these entries are for January 1st 2012. Entries are for 00:20, 00:53, 01:53, etc.

Thanks for the help!