time stamp a cell that doesn,t change when time stamping another

TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
TIME AND NOTE DIFFERENCE BETWEEN STEPS

Hi RC,

You can add the code below to a module, then call the TimeStamp in your
program when needed. Make sure you change the name of the worksheet
("Sheet1") to wherever you want the time stamps to go. Also, change the
Column (currently set to "A").

Each time the TimeStamp is run, it will look for the next available cell in
Column A (on Worksheet "Sheet1") and enter the current date/time value.

Hope that helps.

Regards,
James

Sub TimeStamp()
Dim wkb As Workbook
Dim wks As Worksheet
Dim rng As Range

Set wkb = ThisWorkbook
Set wks = wkb.Worksheets("Sheet1")
' Find last used cell in Column A.
Set rng = wks.Range("A65536").End(xlUp)
' If the last used cell is Row 1 AND is blank, set the time stamp.
If rng.Row = 1 And rng.Value = "" Then
rng.Value = Now()
Else
' Move to the next row down and set the time stamp.
rng.Offset(1, 0).Value = Now()
End If

Set wkb = Nothing
Set wks = Nothing
Set rng = Nothing
End Sub

"RC" wrote:

> TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
> TIME AND NOTE DIFFERENCE BETWEEN STEPS

Take a look here:

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

then just subtract the start time at one process from the end time (or
the start time of the next one) to get the duration.


In article <E16E9353-19E3-4274-88DE-770A7FD9245B@microsoft.com>,
"RC" <RC@discussions.microsoft.com> wrote:

> TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
> TIME AND NOTE DIFFERENCE BETWEEN STEPS

THANKS FOR YOUR REPLY TO MY QUESTION I TYPED IN YOUR CODE WENT GOOD TILL I
GOT TO YOUR LINE 'MOVE TO NEXT. THIS LINE IS REMAINING IN RED PRINT AND
NOTHING IS HAPPENING ON THE WORK SHEET. I AM A EXCEL ROOKIE TRYING TO LEARN,
THANKS AGAIN ALSO THANKS JE

"RC" wrote:

> TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
> TIME AND NOTE DIFFERENCE BETWEEN STEPS

FOUND MY PROBLEM WITH LINE MOVE OK NOW! NEW PROBLEM IS TIME STAMP GIVES ME
1-1-1900 12:00AM AND NOT CLOCK TIME AND DATE. I FORMATED COLUME FOR HH:MM:SS
AGAIN THANKS ALL!!

"RC" wrote:

> TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
> TIME AND NOTE DIFFERENCE BETWEEN STEPS

TO JE McGIMSEY I SET YOUR WORKSHEET EVENT MACRO, AND IT WORKS GREAT!
I WOULD LIKE TO HAVE THE SAME OPTION TO ADD ANTHER SET OF TIME STAMPS IN
OTHER COLUMES NEXT TO IT ,TO BE ABLE TO TIME MORE THAN ONE LINE AT A TIME.
THANKS FOR YOUR INPUT
PS DO KNOW A GOOD TRAINING TOOL FOR EXCEL THAT MY WIFE AND I COULD LEARN
MORE FROM.

"JE McGimpsey" wrote:

> Take a look here:
>
> http://www.mcgimpsey.com/excel/timestamp.html
>
> then just subtract the start time at one process from the end time (or
> the start time of the next one) to get the duration.
>
>
> In article <E16E9353-19E3-4274-88DE-770A7FD9245B@microsoft.com>,
> "RC" <RC@discussions.microsoft.com> wrote:
>
> > TRYING TO FOLLOW A PROCESS AND TIME STAMP AT EACH STEP IN PROCESS THAN TOTAL
> > TIME AND NOTE DIFFERENCE BETWEEN STEPS
>