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