Merge date and time in one column

[Krista1984]

Hi I would like to merge a column with a date and a column with a time into one to show DD/MM/YYYY HH:MM

I applied the following formula: =INT(A1)+MOD(B1,1) - it works for some cells and not others.

e.g. one cell will work perfectly - 1/07/2010 11:57, and the cell below will come up as #VALUE!

Despite this both the date and time columns for the correct working cells and non working cells are in the same format (date 14/03/01; time 13:30:55). Does anyone know how I can solve this problem?

[arlu1201]

Hello Krista1984,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.