Home |
Search |
Today's Posts |
#1
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
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 the seconds as 00. Is there any way to get the seconds also? Thanks |
#3
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
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
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 the seconds as 00. Is there any way to get the seconds also? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Time | Excel Discussion (Misc queries) | |||
Current Time | Excel Discussion (Misc queries) | |||
In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
Can I automatically enter the current date or current time into a | New Users to Excel |