Problems with using Time Stamp...

Hi, i have been using this code to time stamp a particular cell:

Please Login or Register  to view this content.

The only trouble with this code was that it copied over whatever was in the selected cell... So someone helped me out with code that just adds to the selected cell which is much simpler:

Please Login or Register  to view this content.

Now my problem is i need to do a calculation on these dates... With the old code i was able to minus one date from the other to get a number (of days)... with the new code ... when i do the same calculation i just get #VALUE!

Is there a way to get this working? also the old code did not display the seconds in the cell... (but it did display them in the bar at the top)... with the new code it displays the seconds in the cell (which i didnt want) and even if i format the cell to DD/MM/YYYY HH:MM... it still displays seconds can anyone help?

Thanks, i had been doing that at the start using code to stamp into the comments box. But my problem is that i need to do some calculations on the dates... i need to minus one date from the other to work out the days taken... now i only need one date in the cell.... and with the old timestamp code that worked... with my new one it doesnt... anyone have any ideas?