Couple of methods on John McGimpsey's site

One without VBA and one with.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 08:56:01 -0700, ToMMie
wrote:

Hi all,

For example, A1 is column for date input and B1 is for the time date is
input in A1.

If I want excel to automatically show time the date is input, what formula
is used?

Now, i wrote one formula but it doesn't really fit my requirement.
I'm using like =if(a1<"",now())
what I get at frist place seems ok but I just realized that by using this
formula, the time always changes.

Please help

ToMMie