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

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

Post by UkM » Thu, 13 Oct 2005 10:17:02


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

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

Post by SlMyMDA0Uj » Thu, 13 Oct 2005 15:17:01

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

 
 
 

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

Post by JE McGimps » Fri, 14 Oct 2005 01:35:02

Take a look here:

http://www.yqcomputer.com/

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 < XXXX@XXXXX.COM >,
 
 
 

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

Post by UkM » Fri, 14 Oct 2005 05:01:03

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
 
 
 

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

Post by UkM » Fri, 14 Oct 2005 06:20:04

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!!