If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Shortcut for current Time in hh:mm:ss
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 |
#2
|
|||
|
|||
Shortcut for current Time in hh:mm:ss
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 |
#3
|
|||
|
|||
Shortcut for current Time in hh:mm:ss
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 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 |
Thread Tools | |
Display Modes | |
|
|