To all,

I have date and time data in two seperate columns in a worksheet called
' ImportedRawData '. In column A is the date and in Column B is the
time:

17/10/2006 23:10:12


I want to be able to sum the two columns and have put the answer in
Column A of sheet 'ImportedDataEdit'. I can do this if I have two
numbers, but I seem to get a type mismatch error as soon as I start
using dates. I want the final format to be displayed as a custom number
format of

dd.mm.yyyy.hr.min.secs

Any help would be appreciated.

Regards

Joseph Crabtree