Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
needing a keystroke for the current date AND time
I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + :
gives the current time. Is there a keystroke that gives the current date AND time? I'd like to enter a start time quickly in one column and then a closing time in another and have it calculated in a third. The individuals who will be filling out this spreadsheet need a very quick and dirty way to do it. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
needing a keystroke for the current date AND time
If you assign a shortcut key like CNTRL-e to this macro:
Sub DayTime() ActiveCell = Now End Sub It may do the trick -- Gary''s Student - gsnu200812 "Scotta0471" wrote: I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + : gives the current time. Is there a keystroke that gives the current date AND time? I'd like to enter a start time quickly in one column and then a closing time in another and have it calculated in a third. The individuals who will be filling out this spreadsheet need a very quick and dirty way to do it. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
needing a keystroke for the current date AND time
hi
not really. see this sites for keyboard shortcuts 2003 http://www.cpearson.com/excel/KeyboardShortcuts.htm 2007 http://www.keyxl.com/aaa33ef/136/Mic...-shortcuts.htm some shortcuts change in 2007. does that supprise you????? option 1 crtl+; space ctrl+shift+: will put the date and time in a cell but you have to release the crtl key to put the space in. option 2 create a macro Sub EnterDateTime() ActiveCell.value = Now() End Sub then assign your own keyboard shortcut. see the above sites for available keys. to assign a keyboards shortcut... on the 2003 menu bar click toolsmacromacro. In the macro name box, enter the name of the macro you want to assign to a keyboard shortcut key. click options. enter a letter in the shortcut key box. You can use ctrl+ letter (for lowercase letters) or ctrl+shift+ letter (for uppercase letters), where letter is any letter key on the keyboard. the shortcut key letter you use cannot be a number or special character such as @ or #. Note: the shortcut key will override any equivalent default microsoft excel shortcut keys while the workbook that contains the macro is open. if you want to include a description of the macro, type it in the description box. click OK. click cancel. regards FSt1 "Scotta0471" wrote: I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + : gives the current time. Is there a keystroke that gives the current date AND time? I'd like to enter a start time quickly in one column and then a closing time in another and have it calculated in a third. The individuals who will be filling out this spreadsheet need a very quick and dirty way to do it. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
needing a keystroke for the current date AND time
Hi Scott,
You can just combine the two with a space so Ctrl + ; space Ctrl + Shift + : It's a single handed operation if you use the right side of the keyboard. HTH Martin "Scotta0471" wrote in message ... I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + : gives the current time. Is there a keystroke that gives the current date AND time? I'd like to enter a start time quickly in one column and then a closing time in another and have it calculated in a third. The individuals who will be filling out this spreadsheet need a very quick and dirty way to do it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current date and time for different log entries | Excel Discussion (Misc queries) | |||
Current date and time when different cell = X | Excel Worksheet Functions | |||
How to show current date and time | New Users to Excel | |||
How do I sum within a set time frame from the current date? | Excel Worksheet Functions | |||
Can I automatically enter the current date or current time into a | New Users to Excel |