Automatically insert time in excel but not automatically updated
 

I want to insert time automatically in a cell but I don't want the time
updated automatically.

let's say column A is "Customer Name" and column B is "Time Arrive". what i
am trying to make is when i type first customer's name in cell A2 then the
cell B2 should show automatically the time first customer arrives.

Using NOW() function, the time is updated every time i enter value in any
cell (such as: when i type the next customer's name in cell A3, A4, A5, and
so on).

Using Ctrl + Shift + ; i have to manually press those buttons.

Help please ...

Automatically insert time in excel but not automatically updated
 

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
(You can't use formulas as the "date/time stamps" as these will recalc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"NeueN" wrote:
I want to insert time automatically in a cell but I don't want the time
updated automatically.

let's say column A is "Customer Name" and column B is "Time Arrive". what i
am trying to make is when i type first customer's name in cell A2 then the
cell B2 should show automatically the time first customer arrives.

Using NOW() function, the time is updated every time i enter value in any
cell (such as: when i type the next customer's name in cell A3, A4, A5, and
so on).

Using Ctrl + Shift + ; i have to manually press those buttons.

Help please ...

Automatically insert time in excel but not automatically updated
 

Not quite automatic, but if you select the cell and do Ctrl-Shift-Colon, the
time will be inserted without a formula. Other than that it's VBA. HTH
Otto
"NeueN" wrote in message
...
I want to insert time automatically in a cell but I don't want the time
updated automatically.

let's say column A is "Customer Name" and column B is "Time Arrive". what
i
am trying to make is when i type first customer's name in cell A2 then the
cell B2 should show automatically the time first customer arrives.

Using NOW() function, the time is updated every time i enter value in any
cell (such as: when i type the next customer's name in cell A3, A4, A5,
and
so on).

Using Ctrl + Shift + ; i have to manually press those buttons.

Help please ...

Automatically insert time in excel but not automatically updated
 

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Me.Range("A" & n).Value < "" Then
Me.Range("B" & n).Value = Format(Now, "hh:mm:ss AM/PM")
End If
End If
enditall:
Application.EnableEvents = True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste the above into that sheet module. Alt + q to return to the Excel
window.

Enter a name in column A to get a static time in column B


Gord Dibben MS Excel MVP

On Sat, 20 Dec 2008 20:43:00 -0800, NeueN
wrote:

I want to insert time automatically in a cell but I don't want the time
updated automatically.

let's say column A is "Customer Name" and column B is "Time Arrive". what i
am trying to make is when i type first customer's name in cell A2 then the
cell B2 should show automatically the time first customer arrives.

Using NOW() function, the time is updated every time i enter value in any
cell (such as: when i type the next customer's name in cell A3, A4, A5, and
so on).

Using Ctrl + Shift + ; i have to manually press those buttons.

Help please ...

Automatically insert time in excel but not automatically updat
 

Max, Otto Moehrbach, Gord Dibben,

thank you for your help. really solve my problems.