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.