A Time Stamp Formula!

[Aymanh]

Does any body know about a formula that can time stamp the changes in other
cells?

 

[Ron de Bruin]

Hi Aymanh

You need VBA to do that

You can do it with the change event of the worksheet
This example will place the date/time in the B column if you change
a cell in the range A1:A20.

Place the code in the Sheet module

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("a1:a20"), Target) Is Nothing Then
Target.Offset(0, 1).Value = Format(Now, "mm-dd-yy hh:mm:ss")
End If
End Sub


Manual you can do this

you can insert the time like this
CTRL : (colon)

the date like this
CTRL ; (semicolon)

CTRL : (colon) space bar CTRL ; (semicolon)
this will give you both in one cell

 

[Bill Kuunders]

Have a look at an answer from Gord Dibben on 11 10 03 in excel functions
copied below.............