How to display seconds on time stamp?

[Guest]

I'm trying to display the seconds hh:mm:ss when clicking ctrl + shift + ; and
it defaults to 00 for seconds every time. I need to calculate durations when
users click in different cells. How do I set up excel to input the seconds?

 

[Ron de Bruin]

You can use a macro to do it

Sub test()
ActiveCell.Value = Format(Now, "hh:mm:ss")
ActiveCell.NumberFormat = "h:mm:ss AM/PM"
End Sub