ctrl+shift+; trying to get the seconds to show up???

[striperbooter]

After trying to get a time to show seconds wiht a command button i thoughti would come back to the basic's and see if I could not get this short cut to work??? I have formated all the cells wiht the hh:mm:ss so that it should show hours: minutes:seconds but when i hit the ctrl+shift+; the seconds allways default to 00? any ideas or help would be great .. what i a tryig to do is input a time when a car comes into a intersection and then again when it leaves and then find out the gap in time between the two?? all total there will be four colums A: lane 1 car enters the intersection, B: lane 1 car leaves the intersection, C:lane 2 car enters the intersection, d: lane 2 car leaves the intersection so that is where i am at?? and once again thanks for all your help on this problem and look forward to hearing from some of you!!!
zc

 

[Mark W.]

=NOW()

 

[Jaafar Tribak]

Hi Stripper Booter,


You are right.I don't know why this happens

Anyway,if you still want to use the same key combination while stil getting the seconds displayed then do the following:

Select the range of cells you want to enter the Time in.

Give it a name Say For example "DATA" (You can do this via the Name Box to the left of the Formula Bar)

Right click the worksheet Tab,choose View Code and paste the following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Union(Target, Range("DATA")).Address _
    = Range("DATA").Address Then
        Application.OnKey "^+;", "TimeStamp"
    Else
        Application.OnKey "^+;"
    End If

End Sub

In a Standard Module in the same workbook paste this code:

Public Sub TimeStamp()
    ActiveCell.Value = Format(Now, "hh:mm:ss")
End Sub

Hope this helps.

 

[striperbooter]

where or what is a Standard Module ?

 

[striperbooter]

rafaaj2000 you da man !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

it works great!!!!!
thanks again!!!!