Unfortunately I could find only a workaround method, a Change event macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$1" Then 'adjust reference as required!
Target.NumberFormat = "hh:mm:ss"
Target.Value = Time
End If
End Sub

Type anything in cell D1, hitting Enter will store current time with seconds.
Regards,
Stefi

€žBruno€� ezt Ã*rta:

Ok i already solved problem 1!!

Problem 2 is resonably done but i would like to make it more acurate.

The Ctrl+: gives me the correct hh:mm but it doens't give me the seconds
even if i chose hh:mm:ss it shows like 11:41:00.

Is there anything i can change in my EXCEl to give the seconds?