Date format Problem Macro
 

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

Date format Problem Macro
 

Hi
Works for me if I put the date and time in two columns (A1 and B1 say)
and the formula
=A1+B1
in column C.
Check that the date is formatted as a date and the time as a time. You
might also need to edit the custom format you get in column C (my Excel
dropped the seconds). Just go into Format, Cells...and edit the custom
format as required.
regards
Paul
joecrabtree wrote:

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