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

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

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

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

Max, Otto Moehrbach, Gord Dibben,

thank you for your help. really solve my problems.