Time WITHOUT Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 -
 
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
 
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)
 
Back
Top