Date format Problem Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joecrabtree - 18 Dec 2006 09:17 GMT

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

Reply to this Message

paul.robinson@it-tallaght.ie - 18 Dec 2006 09:51 GMT

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

> To all,
>
[quoted text clipped - 17 lines]
>
> Joseph Crabtree

Reply to this Message