how do you store real time in excel when making an entry

J

jhbarajas

Hello,
I want to store a date and time stamp in a cell when i enter a vale in
another.
For example:

I have Col A .. called "id" .. in each row under that column i will enter a
number and or letters

I have Col B .. call it "date and time" .. i want it to store in the cell
the exact date and time including seconds .. when the value was entered into
the Col A Row 1

In other words I want to record the exact date and time when an entry was
made from the adjacent column.

I tried using NOW() but then when i made an entry the whole date and time
was changed for every cell. I want to freeze (the date and time of every
entry). The date and time for the each entry needs to be recored as I ener
the value AND it need not chnage the rest.

Can someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixing date of entry 14
How do I lock a stamp date/time formula for an entry on a row? 3
put date and time in cells after entry made in shared workbook 2
separating date and time 5
static "now" values 5
Formula that will record the time and date when an entry is made on a sheet 3
Automate date & time entry 1
Place Date in One column when entry is made in another column. 3

Top