Help!

Shortcut for current Time in hh:mm:ss

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  PowerPoint 2007 Printing issues  
Author Message
Radhakant Panigrahi
External


Since: Apr 19, 2010
Posts: 5



PostPosted: Thu May 13, 2010 5:31 am    Post subject: Shortcut for current Time in hh:mm:ss
Archived from groups: microsoft>public>excel>misc (more info?)

Hi,

i need to enter the current time in a cell with hh:mm:ss foramt
there is a short cut CTRL+SHIFT+:, although it shows me the hh:mm:ss, but
the second is always in 00.is there any other way that i can enter the
current time.

And i need to find the difference between two times in the same format
hh:mm:ss. So is there any formala to find the difference between two times in
hh:mm:ss format.

regards,
radhakant
Back to top
ck13
External


Since: Mar 16, 2010
Posts: 8



PostPosted: Thu May 13, 2010 6:34 am    Post subject: RE: Shortcut for current Time in hh:mm:ss [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

1. Assuming that the cell where you input the time is at a fixed location,
enter this into the cell =NOW() and format it as hh:mm:ss to update the
time, press F9.

2. Use the latest time to subtract the earliest time and format the cell as
hh:mm:ss

Hope this helps.

"Radhakant Panigrahi" wrote:

> Hi,
>
> i need to enter the current time in a cell with hh:mm:ss foramt
> there is a short cut CTRL+SHIFT+:, although it shows me the hh:mm:ss, but
> the second is always in 00.is there any other way that i can enter the
> current time.
>
> And i need to find the difference between two times in the same format
> hh:mm:ss. So is there any formala to find the difference between two times in
> hh:mm:ss format.
>
> regards,
> radhakant
Back to top
Ms-Exl-Learner
External


Since: Sep 15, 2009
Posts: 14



PostPosted: Thu May 13, 2010 6:49 am    Post subject: RE: Shortcut for current Time in hh:mm:ss [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Open the Excel File>>Press Alt+F11>>Insert>>Module>>Copy and Paste the below
Code

Public Sub Current_Time()
ActiveCell = Format(Now(), "HH:MM:SS")
End Sub

File>>Close and Return to Microsoft Excel (OR) Press Alt+Q to close the
Microsoft Visual Basic Window.

Tools>>Macro>>Macros>>Select Current_Time>>Select Options and Press your
desired Shortcut Key for this Macro. (For Example press “q” as shortcut key)
and give Ok.

Now place the cursor in any cell in the current (Macro Created) Workbook and
press the shortcut key assigned by you followed by the Cntrl Key. In this
example it is Cntrl+Q. (Cntrl+Your shortcut button). Now it will show the
Current Time with seconds and it won’t change.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Radhakant Panigrahi" wrote:

> Hi,
>
> i need to enter the current time in a cell with hh:mm:ss foramt
> there is a short cut CTRL+SHIFT+:, although it shows me the hh:mm:ss, but
> the second is always in 00.is there any other way that i can enter the
> current time.
>
> And i need to find the difference between two times in the same format
> hh:mm:ss. So is there any formala to find the difference between two times in
> hh:mm:ss format.
>
> regards,
> radhakant
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum