needing a keystroke for the current date AND time

[Scotta0471]

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.

 

[Gary''s Student]

If you assign a shortcut key like CNTRL-e to this macro:

Sub DayTime()
ActiveCell = Now
End Sub

It may do the trick

 

[FSt1]

hi
not really. see this sites for keyboard shortcuts
2003 http://www.cpearson.com/excel/KeyboardShortcuts.htm
2007
http://www.keyxl.com/aaa33ef/136/Microsoft-Excel-Software-keyboard-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 tools>macro>macro.
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

 

[MartinW]

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