Time Stamp based on cell change

[doubl3d80]

I have searched for this and tried different techniques out but nothing works like I want it to. I want a time stamp displayed when a certain cell is changed but only when things are actually changed. The ones that work so far will update the time even when the cell is double clicked to enter text. That won't really work because I know that cells will be clicked on and updated with nothing changed and that messes up when the cell was actually last changed.

Here is one forumula that does works but changes when a cell is clicked to enter text but nothing actually changes.

=IF(C3<>"",IF(B3="",NOW(),B3),"")

[dilipandey]

Hi double3d80,

Do you need a time stamp when C3 is not equal to blank and B3 equals to blank.... ?

Regards,
DILIPandey

<click on below 'star' if this helps>

[doubl3d80]

The time stamp that I need would just be anytime text is actually changed in a cell it would time stamp the next cell over.

[dilipandey]

Ok. so if any cell cell value changed, you want the cell on right side should be time stamped with NOW?

Regards,
DILIPandey

<click on below 'star' if this helps>

[doubl3d80]

Correct. If the text in cell A1 was changed then I would like cell B1 to have a time stamp. But I want it done only if text is actually altered.

[dilipandey]

Hi doubl3d80,

I believe then the only solution is vba (macros).. let me know if this is OK with you... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[doubl3d80]

Would these be triggered when they enter items or would they have to click something to run them?

[dilipandey]

These can be triggered when they enter items...
But we may need to define columns .. like column A would be data and column B would be for time stamping.. e.g., A1 is changed B1 should be time stamped.


Regards,
DILIPandey

<click on below 'star' if this helps>

[doubl3d80]

That sounds like it would work out.

[dilipandey]

But we may need to define columns .. like column A would be data and column B would be for time stamping.. e.g., A1 is changed B1 should be time stamped.

What are your thoughts on above ?

Regards,
DILIPandey


<click on below 'star' if this helps>

[doubl3d80]

Could you make it so that column B is for data and column C would be for time stamping? That would work great.

[dilipandey]

Hi double3d80,

Welcome to the forum.

See the attached file and change / type any content in column B, you'll get the time stamp on column C. thanks.
date stamp on col c.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>

[kmgibson]

Hi Dilipandey -

Would you be able to do one as the above but also add in column E another time stamp? I need the last one for "time completed." If you could do that I'm guessing it's still possible to show in column F time spent of project... correct? Is it also possible to tell me the steps you took to create that Macro?

Thank you so much for your help!

[dilipandey]

Hi Kmgibson,

I would suggest you to open the workbook, press Alt + F11 and double click the sheet name in left window pane.. you'll see the code and I am sure you can edit it easily.. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>