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