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

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

Open the Excel FilePress Alt+F11InsertModuleCopy and Paste the below
Code

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

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

ToolsMacroMacrosSelect Current_TimeSelect 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 wont 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