How to display seconds on time stamp?



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question