Shortcut for current Time in hh:mm:ss

Radhakant Panigrahi · External Since: Apr 19, 2010 Posts: 5

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

ck13 · External Since: Mar 16, 2010 Posts: 8

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

Ms-Exl-Learner · External Since: Sep 15, 2009 Posts: 14

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