Question by  sshheraz (18)

How do you do an automatic time stamp in excel?

I need to do an automatic time stamp in excel.


Answer by  ahsanmahmoodawan (1169)

I'm telling you manual entry typing ctrl-; will enter current date in cell typing ctrl-shift-; will enter current time


Answer by  dave246 (35)

In a cell type =NOW() and you'll get the current time stamp. However time changes each second so you need to hit F9 to update the cell. When you want to freeze the timestamp just copy and paste special as value and it will then it will become an unchanging cell when the next calculation of the spreadsheet is done.


Answer by  worker8836 (9)

Current time Select a cell and press CTRL+SHIFT+; Current date and time Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;


Answer by  fiddlefaddle (883)

While this can be done manually, or by using circular references and worksheet functions, the best way of time or date stamping a change to a cell in the worksheet is usually to use a worksheet event macro.


Answer by  Anthony21 (24)

The following macro should do what you are asking: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:A")) Is Nothing Then Cells(Target.Row, 5).Value = Now() End If End Sub


Answer by  gigo (1706)

For something like that you can use the now() function. With the text function you have additionally the possibility to convert the time/date output.


Answer by  senthil34 (169)

When data is entered in a cell, the adjacent cell records the current time. This is a sheet for machine operators to keep track of their progress. Go to Tools  Options  Calculation Tab  Check the Iteration checkbox. Use the IF and NOW functions as shown in the following formula: =IF(A2=",",IF(B2="",NOW(),B2)) Apply "mm/dd/yyyy hh:mm" format to column B.

You have 50 words left!