How to display seconds on time stamp?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top