Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The shortcut to enter time in excel should include seconds.
The shortcut to enter the current time in an Excel workbook should include
seconds. Currently, if you hit CTRL+: (SHIFT ;) the current time is displayed in the appropriate cell as 1:14 PM b default. Formatting the time to read h:mm:ss, it is displayed with the seconds as :00 |
#3
|
|||
|
|||
I really appreciate the info. However, I'm not very saavy with this sort of
thing. In fact, I don't even know how to begin altering the setup like this. If you wouldn't mind, could you take me through how to do this step by step? Thanks. "JE McGimpsey" wrote: This is a peer-to-peer newsgroup. To submit suggestions to MS, send an email to . FWIW, my default setup does exactly that. In my startup template (in the startup folder) I have something like: Private Sub Workbook_Open() Application.OnKey "^+;", "EnterTime" End Sub and in a regular module: Public Sub EnterTime() With Selection .NumberFormat = "hh:mm:ss" .Value = Time End With End Sub In article , "JoeGill" wrote: The shortcut to enter the current time in an Excel workbook should include seconds. Currently, if you hit CTRL+: (SHIFT ;) the current time is displayed in the appropriate cell as 1:14 PM b default. Formatting the time to read h:mm:ss, it is displayed with the seconds as :00 |
#4
|
|||
|
|||
Joe,
Probably best to add this to your Personal.xls. First check if you have one. Go to WindowUnhide and see if there is a Personal. xls file there. If there is not create one by creating a simple macro. Go to ToolsMacroRecord New Macro. In the dropdown, select Personal Macro Workbook. As soon as the recording starts, a small toolbar with stop Recording button. Click this button. Re-do the WindowUnhide stuff. Select the Personal.xls to make it visible. In this workbook, right-click the Excel icon at the top-left of the Personal.xls spreadsheet, and select View Code. You will be presented with the VBE, and an open code module. Enter John's code into the code module. Close the VBE. Select the Personal.xls spreadsheet, save it, and then hide it, WindowHide. -- HTH RP (remove nothere from the email address if mailing direct) "JoeGill" wrote in message ... I really appreciate the info. However, I'm not very saavy with this sort of thing. In fact, I don't even know how to begin altering the setup like this. If you wouldn't mind, could you take me through how to do this step by step? Thanks. "JE McGimpsey" wrote: This is a peer-to-peer newsgroup. To submit suggestions to MS, send an email to . FWIW, my default setup does exactly that. In my startup template (in the startup folder) I have something like: Private Sub Workbook_Open() Application.OnKey "^+;", "EnterTime" End Sub and in a regular module: Public Sub EnterTime() With Selection .NumberFormat = "hh:mm:ss" .Value = Time End With End Sub In article , "JoeGill" wrote: The shortcut to enter the current time in an Excel workbook should include seconds. Currently, if you hit CTRL+: (SHIFT ;) the current time is displayed in the appropriate cell as 1:14 PM b default. Formatting the time to read h:mm:ss, it is displayed with the seconds as :00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I get real time stock quotes to my excel worksheet? | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
Cancelling shortcut ctrl-click which opens "Research" in Excel 200 | Excel Discussion (Misc queries) | |||
Is there a keyboard shortcut for centering data in Excel? | Excel Discussion (Misc queries) |