Shortcut for current Time in hh:mm:ss

  • Thread starter Thread starter Radhakant Panigrahi
  • Start date Start date
R

Radhakant Panigrahi

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.
 
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!
 
Back
Top