Time WITHOUT Updating

[Guest]

Is there a way I can add an Excel column that has just the current time stamp (no date), but without updating the other times? I'd like this to happen automatically, like a formula. I've tried Macros, Now () function, etc. but everything updates the other entries

For example

Entry #1 | Time Entere
Entry #2 | Time Entere

Thanks -

 

[Frank Kabel]

Hi Melissa

You have to use some VBA code. E.g. Harlan Grove posted a solution some
days ago (I really liked his idea
as you can use the defined name in any formula on your spreadsheet).
e.g.
IF(A1<>"",_NOW_,"")

look at
http://tinyurl.com/2clq7
for the VBA code

HTH
Frank

 

[JE McGimpsey]

Take a look here:

http://mcgimpsey.com/excel/timestamp.html

 

[Bob Phillips]

Frank,

Don't think this will work in this case as the time is frozen when the name
is created, so will not reflect when the formula is entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob,
you're right. JE's solution is better
Regards
Frank