|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 15th, 2009, 07:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
current time
When I use (ctrl+shft+
 to get the current time it always displays the seconds as 00. Is there any way to get the seconds also? Thanks 
|
|
#2
November 15th, 2009, 07:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
current time
That is the accuracy of the procedure. If you want more, use =NOW()
best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "dummy" wrote in message ... When I use (ctrl+shft+ to get the current time it always displays theseconds as 00. Is there any way to get the seconds also? Thanks
|
|
#3
November 16th, 2009, 06:34 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
current time
But in the Now() function the time will be keep on changing to the current
system time, so you can use a small Time Macro To capture the Current Timing with seconds. Press ALT+F11 and go to Insert and click Module and paste the below code. Sub Cur_Time() ActiveCell = Time End Sub After pasting the code close the VBA and press ALT+F8, the Cur_Time Macro will appear. Just select it and select Options and give your desired keyboard button as shortcut key to run the macro. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "dummy" wrote: When I use (ctrl+shft+ to get the current time it always displays the seconds as 00. Is there any way to get the seconds also? Thanks
|
|
#4
November 16th, 2009, 10:32 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
current time
Format the cell in custom as hh:mm
"dummy" wrote: When I use (ctrl+shft+ to get the current time it always displays the seconds as 00. Is there any way to get the seconds also? Thanks
|
|
#5
November 16th, 2009, 10:49 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
current time
And how does that get the seconds to be non-zero?
-- David Biddulph "JAF-In" wrote in message ... Format the cell in custom as hh:mm "dummy" wrote: When I use (ctrl+shft+ to get the current time it always displays theseconds as 00. Is there any way to get the seconds also? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
