Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date/Time stamp with one stroke?
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. |
#2
|
|||
|
|||
As an additional note, I did try changing the formatting of the cells to Date
and Time, then using CTRL + ; to put in the current stamp. This does add a time, but it will only add midnight. "Reverse_Solidus" wrote: 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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
Hi
Have you tried =NOW() and then format as time / Custom h:mm:ss HTH Michael "Reverse_Solidus" wrote: 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. |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
Just a thought, but if you enter a formula that includs the current time and
date, isn't is going to update itself constantly, every time you open or recalculate your workbook? Thus, if you finish a job today and open the workbook tomorrow, it'll show tomorrow's date! One way to get around this is to convert the formula to a value using paste special, once you've entered it into the cell. You would do it like this: Sub InsertDate_Time() With ActiveCell .Value = Now .NumberFormat = "mm/dd/yy h:mm AM/PM" .Copy .PasteSpecial Paste:=xlValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End With Application.CutCopyMode = False 'empties the clipboard End Sub Hope this helps Pete "Reverse_Solidus" wrote: 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. . |
#7
|
|||
|
|||
but you used .value (not .formula).
So the copy|paste special|values is not necessary. Peter Rooney wrote: Just a thought, but if you enter a formula that includs the current time and date, isn't is going to update itself constantly, every time you open or recalculate your workbook? Thus, if you finish a job today and open the workbook tomorrow, it'll show tomorrow's date! One way to get around this is to convert the formula to a value using paste special, once you've entered it into the cell. You would do it like this: Sub InsertDate_Time() With ActiveCell .Value = Now .NumberFormat = "mm/dd/yy h:mm AM/PM" .Copy .PasteSpecial Paste:=xlValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End With Application.CutCopyMode = False 'empties the clipboard End Sub Hope this helps Pete "Reverse_Solidus" wrote: 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. . -- Dave Peterson |
#8
|
|||
|
|||
Dave,
Whoops, you're quite right - that'll teach me to pass comment about other peoples' perfectly satisfactory solutions! :) Pete "Dave Peterson" wrote: but you used .value (not .formula). So the copy|paste special|values is not necessary. Peter Rooney wrote: Just a thought, but if you enter a formula that includs the current time and date, isn't is going to update itself constantly, every time you open or recalculate your workbook? Thus, if you finish a job today and open the workbook tomorrow, it'll show tomorrow's date! One way to get around this is to convert the formula to a value using paste special, once you've entered it into the cell. You would do it like this: Sub InsertDate_Time() With ActiveCell .Value = Now .NumberFormat = "mm/dd/yy h:mm AM/PM" .Copy .PasteSpecial Paste:=xlValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End With Application.CutCopyMode = False 'empties the clipboard End Sub Hope this helps Pete "Reverse_Solidus" wrote: 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. . -- Dave Peterson |
#9
|
|||
|
|||
Doesn't stop me!
Sometimes, the words change between viewings! Peter Rooney wrote: Dave, Whoops, you're quite right - that'll teach me to pass comment about other peoples' perfectly satisfactory solutions! :) Pete "Dave Peterson" wrote: but you used .value (not .formula). So the copy|paste special|values is not necessary. Peter Rooney wrote: Just a thought, but if you enter a formula that includs the current time and date, isn't is going to update itself constantly, every time you open or recalculate your workbook? Thus, if you finish a job today and open the workbook tomorrow, it'll show tomorrow's date! One way to get around this is to convert the formula to a value using paste special, once you've entered it into the cell. You would do it like this: Sub InsertDate_Time() With ActiveCell .Value = Now .NumberFormat = "mm/dd/yy h:mm AM/PM" .Copy .PasteSpecial Paste:=xlValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End With Application.CutCopyMode = False 'empties the clipboard End Sub Hope this helps Pete "Reverse_Solidus" wrote: 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. . -- Dave Peterson -- Dave Peterson |
#10
|
|||
|
|||
Great responses if you use word or excel. Any idea how to do this in
Outlook? -Erin ) "Reverse_Solidus" wrote: 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. |
#11
|
|||
|
|||
Maybe posting in an Outlook newsgroup would get better responses.
Erin wrote: Great responses if you use word or excel. Any idea how to do this in Outlook? -Erin ) "Reverse_Solidus" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
Date/Time Macro | Excel Discussion (Misc queries) | |||
How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
Calculating date/time | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |