How to display seconds on time stamp?

's Computer Specifications

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?

's Computer Specifications

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"uosam" <(E-Mail Removed)> wrote in message news:654B0F0E-46B8-4447-96C6-(E-Mail Removed)...
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Track Changes Date/Time stamp in Reviewing Pane	David Newmarch	Microsoft Word Document Management	3	4th Sep 2009 04:47 PM
display no seconds in time format [h]	=?Utf-8?B?Rmlub2xhYw==?=	Microsoft Excel Misc	1	3rd Oct 2005 03:19 PM
the system cannot display the time with seconds	=?Utf-8?B?aG9ybg==?=	Windows XP General	1	13th May 2005 06:09 AM
1. time/date stamp as key & 2. total'g, av'g minutes & seconds	gcp	Microsoft Access Getting Started	2	13th Jul 2004 02:21 AM
display seconds as time	Lane	Microsoft Access Forms	1	28th Feb 2004 10:05 AM