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