How to display seconds on time stamp?

U

uosam

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?
 
R

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
 
Top