Record timestamp in one column automatically

1] Set you column I's format as Custom: m/d/yyyy h:mm [E.g. Column I6]
2] Type this in column I6

=IF(A6>0,NOW(),"")

That should do it. Have tried on my excel sheet and it works fine. ( if you just want the time set format as h:mm)

The problem is when somebody enter something else in any cell, the time is going to change!

The problem is when somebody enter something else in any cell, the time is going to change!

Originally Posted by gmaz2

I am creating a worksheet in excel 2003. Want to use this for attendance log.
As we input numercial data in column B, we would like in column I to create a formula that automatically inputs the actual time that info was entered in column B. Appreciate any assistance.
Thank you

I had tried the Now() IF option before I posted this request, and found that the timestamp updates by the minute, or second depending upon the formated cell h:mm or h:mm:ss etc. Once the numeric value in column b9 say is entered, in column I the time stamp entered should not change. I think this takes a Macro, or some code in VB. This is not in my expertise. Thank you very much for the suggestion though!! Still looking for ideas-

Originally Posted by DonkeyOte

generally 2 options:

1 - VBA
2 - Iteration (circular references)

The latter only really viable if you only want the time stamp to update once - ie the very first time you enter data into cell.

See here for a thread on a similar theme - I provide instructions on both methods:

http://www.excelforum.com/excel-gene...e-problem.html

Thank you for this insight, it is what I think I am looking for. My spread has headers rows 1->8. In Column B we input number data, a barcode stamp 1011 say, then in Column I, this is where we want the in time stamp to go, and not change in that column as new entries are inputted down the page. The in column K9, when the child is picked up we enter another barcode stamp, and then column M9, we want the pick up timestamp inserted in that field; with the same rule applied.

If you help me with this, and provide a little more step by step, I should be able to get thru this-THANKS S-O-O-O MUCH

First of all--THANK YOU SO MUCH for your guidance-I tired the excel formula, =IF(AND(B9<>"",I9=0),NOW(),I9), found that when I copied the formula into the cell, the time stamp appeared, and no value was inputed in to the B9 column, and when I typed the value 1011 say, the time would not change as you stated in your example. I added to the formula string at that point
=if(b9=0,"",to keep the formula hidden, which was successful. But at that point, no time data appeared in column I when I enter a numeric value in column B.

I tried attaching my document to this email, but the server was down, I am not a VBA user, so I really don't have the expertise to work with this-
Here is a sample of the fields. The example with 2150 then the time was a workaround attempt of mine, until the form can do what I was hoping for--that 9:50PM column will be deleted.
BAR CODE NUMBER IN NAME TIME IN BAR CODE NUMBER OUT PARENT\GUARDIAN SIGNATURE TIME OUT
SAMPLE FIELD
1001 SMITH, MARY 2150 9:50 PM 1001 JOE SMITH 2050 8:50 PM
1011 Austin, Alexa 10:21 AM 1011 10:22 AM


Again thankyou for your help.
Greg

Your're awesome first of all--
When you enter a numeric value in column B, the time is reported in column I as say 04:32pm, then you go to column J to input a numeric value, and current time stamp is entered in the same cell, it doesn't appear in column L

Example:
Column B Column I Column J Column L
1011 04:12 PM 04:13 PM

Thank you very much-everything works great.

i want to enter data in A and time of the data entry in B please help me i have used
now() with iteration 1 but doest work

Originally Posted by VBA Noob

Maybe

Please Login or Register  to view this content.

I just had an opportunity to run this script in action-found one small problem-entered data in column b, time stamp appeared as planned in column i. Then entered data in column j, time stamp entered in column L, as scripted. I wonder, is it possible when data is entered in column b9 (which the first data row/field) the cursor drops down to b10, which it now does, BUT when data is entered into column j9, that the cursor tabs to column k10, and still enters time stamp in column L10 as scripted above??

Originally Posted by VBA Noob

I assume you would enter a number in Col K not J as that was a time cell.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Where Case 10 is Column J and the 3 is the offset to Col M

VBA Noob

I just had an opportunity to run this script in action-found one small problem-entered data in column b, time stamp appeared as planned in column i. Then entered data in column j, time stamp entered in column L, as scripted. I wonder, is it possible when data is entered in column b9 (which the first data row/field) the cursor drops down to b10, which it now does, BUT when data is entered into column j9, that the cursor tabs to column k10, and still enters time stamp in column L10 as scripted above??

VBA NOOB

Back on Jan 11, you helped me with a script that inputted a time stamp in a given location.
Well I got a change to test this spread sheet, using the script, and run into an issue.
Found one small problem-entered data in column b, time stamp appeared as planned in column i. Then entered data in column j, time stamp entered in column L, as scripted. I wonder, is it possible when data is entered in column b9 (which the first data row/field) the cursor drops down to b10, which it now does, BUT when data is entered into column j9, that the cursor tabs to column k9, and still enters time stamp in column L9 as scripted above??
What I discovered is that when data was entered in J9, we had to click on K9, so we could enter a signature using EPAD software.

Appreciate it if you could revisit my thread.

Thank you very much
gmaz2