Automatically insert time in excel but not automatically updated

  • Thread starter Thread starter NeueN
  • Start date Start date
N

NeueN

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
 
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
 
NeueN said:
Max, Otto Moehrbach, Gord Dibben,

thank you for your help. really solve my problems.
Click to expand...
I am also facing a similar problem but with a little twist... Request all the experts to help me on this...

I run a saloon and I need to track the In time of customers as soon as they register themselves at the reception. So my first problem of entering the in time automatically was solved now the second problem is that I also need to give them the approximate wait time which I calculate automatically using a couple of formulas...

I have attached the excel sheet which i use for tracking..

I request all the experts to kindly help in automatically entering the customers Turn Time adjacent to there enter time....

Kindly look at the attachment
 

Attachments

Back
Top