**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I want a formula to be able to record the current time when a cell was entered but I do not want it to change when another cell is entered. eg I want a column where i can eneter a number and an adjacent cell to record the time it was entered.
Thanks

Solved by A. E. in 19 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
28/07/2018 - 01:50

Hello!

Excelchat Expert
28/07/2018 - 01:50

Welcome to got it pro!

User
28/07/2018 - 01:51

hi

Excelchat Expert
28/07/2018 - 01:51

I saw your question regarding how to use 2 columns. 1 for entering time and another one for recording time

Excelchat Expert
28/07/2018 - 01:51

is that correcT?

User
28/07/2018 - 01:51

Not quite...1 column to enter a value and another column to record the time it was entered.

Excelchat Expert
28/07/2018 - 01:52

Ok

Excelchat Expert
28/07/2018 - 01:52

I saw that you already have the formula for that

User
28/07/2018 - 01:53

i want the time record to remain as a fixed value each time

Excelchat Expert
28/07/2018 - 01:53

ok

Excelchat Expert
28/07/2018 - 01:53

could you show me how the formula looks like?

User
28/07/2018 - 01:54

I cannot find a formula to work

User
28/07/2018 - 01:55

I cannot use now() as it changes each sheet update

User
28/07/2018 - 01:55

and all the time records are the same

Excelchat Expert
28/07/2018 - 01:55

Yes. Because your question is more macro or vba related type of questions and we are current not support the vba coding services

Excelchat Expert
28/07/2018 - 01:55

I think there are certain coding needs to be done

User
28/07/2018 - 01:56

ok any hints on where a macro may do the job?

Excelchat Expert
28/07/2018 - 01:56

Since you need to records the system when data enter the cell

User
28/07/2018 - 01:56

ok...not so straight forward then?

Excelchat Expert
28/07/2018 - 01:56

I think you have to consider using the system time

Excelchat Expert
28/07/2018 - 01:56

which allow you to use it as timestamp

Excelchat Expert
28/07/2018 - 01:57

whenever the input created then time stamp created at that momnet

User
28/07/2018 - 01:57

I can get the system time but I cannot get it to stay as the value it was when the cell was entered

Excelchat Expert
28/07/2018 - 01:57

Even after it move to next row and previous row records cant be kept overthere

Excelchat Expert
28/07/2018 - 01:57

?

Excelchat Expert
28/07/2018 - 02:00

There should be certain way you can use timstamp function and once A1 is entered

Excelchat Expert
28/07/2018 - 02:00

then goes to A2

Excelchat Expert
28/07/2018 - 02:00

then whenever that 15 was entered in A2 then timestamp give a time in B2

User
28/07/2018 - 02:01

yes but it updates to system time when and overwrites all the other values

Excelchat Expert
28/07/2018 - 02:01

Hmm

Excelchat Expert
28/07/2018 - 02:02

Can you try enter one value and then add a "save function" as well for each value entered

User
28/07/2018 - 02:02

even in a formula the times all update... i need to save that time value so it doesn't get overwritten

User
28/07/2018 - 02:02

save function?

Excelchat Expert
28/07/2018 - 02:02

Yes for each row

User
28/07/2018 - 02:03

not familiar with that

Excelchat Expert
28/07/2018 - 02:03

Save the records first and then convert it into text/time format rather than keep using timer in row 1

User
28/07/2018 - 02:04

so convert the record in col b to a text value? But won't it just get over written next update?

Excelchat Expert
28/07/2018 - 02:05

i dont think so, since B1 will be show as a time in the 2nd loop when next record entered in row 2

Excelchat Expert
28/07/2018 - 02:05

I think this might be a idea for the macro part

Excelchat Expert
28/07/2018 - 02:06

But for more details you may need to find out more

Excelchat Expert
28/07/2018 - 02:06

:-)

User
28/07/2018 - 02:07

OK thanks for the help anyway. I may need to look at a macro. I wanted to simply input a time and have the entry timestamped permanently

User
28/07/2018 - 02:08

Cheers.....I have given you something to think about.

User
28/07/2018 - 02:08

evanharris@exemail.com.au if you think of soemthing. Cheers

Excelchat Expert
28/07/2018 - 02:09

Thanks for sharing this question with me!

Excelchat Expert
28/07/2018 - 02:09

Pllease feel free to provide me some feedback at the end of this session

Excelchat Expert
28/07/2018 - 02:09

Once again, welcome to got it pro!

User
28/07/2018 - 02:10

:)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*