Excellent! That works great. Thank you very much!

"Jason Morin" wrote:

You could do it with a macro. Press ALT+F11, go to Insert
Module, and paste in the code below. Press ALT+Q to
close the Visual Basic Editor:

Sub InsertDate_Time()
With ActiveCell
.Value = Now
.NumberFormat = "mm/dd/yy h:mm AM/PM"
.Offset(1, 0).Select
End With
End Sub

---
Now go to Tools Macro Macros and make sure the macro
name is highlighted. Press "Options" and insert a letter
such as lowercase "a". Your shortcut is now Ctrl+a.

HTH
Jason
Atlanta, GA


-----Original Message-----
I know that you can have Excel insert the current date
with CTRL + ; and the
current time with CTRL + SHIFT + :. Is there some way
to insert both with
one command?

I know it seems like a small thing, but we have a
worksheet for employees to
keep track of completed tasks. When they complete a
given task, they need to
put the date and time of completion in a specific cell.
However, over the
course of a day, they may be completing upwards of 250
tasks. Even lessening
the time to complete the time stamp by a single set of
keystrokes would be
helpful.
.