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" <(E-Mail Removed)> wrote in message
news:35B1A73C-49E8-4D7F-BAEE-(E-Mail Removed)...
>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 <(E-Mail Removed)>
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.

[sachin.schauhan]

Originally Posted by NeueN

Max, Otto Moehrbach, Gord Dibben,

thank you for your help. really solve my problems.

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