Time Stamping

Teryl · May 13th, 2002, 11:04 AM

Hello Everyone,
Is there a way to get excel to apply an auto time stamp to a spreadsheet. I've tried to get users to type in the formula =NOW(), but that doesn't work because when you reopen the file the formula changes the time and date to the current status. I need a time stamp or macro to use for when users are making calls out to employees for overtime. I need to record the exact time the call was made. Please help...thanks

Brian from Maui · May 13th, 2002, 11:08 AM

CTRL + SHIFT + :

Another way, which could be cumbersome is to
type =now() into any cell and name it. Highlight the cells into which the user inputs the date/time stamp, go to Data/validation/List/Source

[ This Message was edited by: brian from maui on 2002-05-13 10:21 ]

Mark W. · May 13th, 2002, 11:08 AM

Control+:

Teryl · May 13th, 2002, 12:11 PM

Hello Brian and Mark
Thanks so much for the tip. It works fine except for one thing control ; gives me the correct date but the wrong time (my cells are formatted for date and time) and the other control + shift + : give me the wrong date but the correct time. What am I doing wrong?

Mark W. · May 13th, 2002, 12:16 PM

Quote:

On 2002-05-13 11:11, Teryl wrote:
Hello Brian and Mark
Thanks so much for the tip. It works fine except for one thing control ; gives me the correct date but the wrong time (my cells are formatted for date and time) and the other control + shift + : give me the wrong date but the correct time. What am I doing wrong?

Your original posting requested "...a time stamp". So that's why I suggested...

Control+: (colon)

If you need a date/time stamp then do the following...

1. Control+; (semicolon)
2. Press the space bar
3. Control+: (colon)
4. Enter

[ This Message was edited by: Mark W. on 2002-05-13 11:18 ]

Teryl · May 13th, 2002, 01:17 PM

Thanks my Time Stamping problem is solved. Mark, thanks so much. I love this site.

rchogan42 · Dec 27th, 2007, 04:41 PM

The Ctrl Shift : + Ctrl Shift ; will give me a date and time... is there a way to automate this to be a macro? \

Thanks in advance for your help.

lenze · Dec 27th, 2007, 04:57 PM

Or you could use a Double_Click

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column <> 4 Then Exit Sub
Target.Value = Now
Cancel = True
End Sub

lenze

wvfitz · Jan 9th, 2008, 12:07 PM

I am uncertain about the cntrl + as when I hit those keys I get an window to shift cells.

How do I correct for this to realize a date/time stamp in a cell?

Thank you.

Datsmart · Jan 9th, 2008, 12:21 PM

You do NOT use the "+" key.

Follow these steps:
1. Control; (semicolon)
2. Press the space bar
3. Control: (colon)
4. Enter

Dec 27th, 2007, 04:41 PM	#7
rchogan42 New Member Join Date: Aug 2005 Location: Minnesota Posts: 15	One more step??? Re: Time Stamping The Ctrl Shift : + Ctrl Shift ; will give me a date and time... is there a way to automate this to be a macro? \ Thanks in advance for your help.

Dec 27th, 2007, 04:57 PM	#8
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Re: One more step??? Re: Time Stamping Or you could use a Double_Click Code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column <> 4 Then Exit Sub Target.Value = Now Cancel = True End Sub lenze __________________ If you have to tell your boss you're good with Excel, you're NOT!! All I know about Excel I owe to my ignorance! Scotch: Because you don't solve great Excel problems over white wine

Jan 9th, 2008, 12:07 PM	#9
wvfitz New Member Join Date: Jul 2006 Location: Wisconsin Posts: 16	Re: Time Stamping I am uncertain about the cntrl + as when I hit those keys I get an window to shift cells. How do I correct for this to realize a date/time stamp in a cell? Thank you.

Jan 9th, 2008, 12:21 PM	#10
Datsmart Board Regular Join Date: Jun 2003 Location: Olympia Posts: 7,942	Re: Time Stamping You do NOT use the "+" key. Follow these steps: 1. Control; (semicolon) 2. Press the space bar 3. Control: (colon) 4. Enter __________________ John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 11:04 AM	#1
Teryl New Member Join Date: Feb 2002 Posts: 19	Hello Everyone, Is there a way to get excel to apply an auto time stamp to a spreadsheet. I've tried to get users to type in the formula =NOW(), but that doesn't work because when you reopen the file the formula changes the time and date to the current status. I need a time stamp or macro to use for when users are making calls out to employees for overtime. I need to record the exact time the call was made. Please help...thanks

May 13th, 2002, 11:08 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	CTRL + SHIFT + : Another way, which could be cumbersome is to type =now() into any cell and name it. Highlight the cells into which the user inputs the date/time stamp, go to Data/validation/List/Source [ This Message was edited by: brian from maui on 2002-05-13 10:21 ]

May 13th, 2002, 11:08 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Control+:

May 13th, 2002, 12:11 PM	#4
Teryl New Member Join Date: Feb 2002 Posts: 19	Hello Brian and Mark Thanks so much for the tip. It works fine except for one thing control ; gives me the correct date but the wrong time (my cells are formatted for date and time) and the other control + shift + : give me the wrong date but the correct time. What am I doing wrong?

May 13th, 2002, 01:17 PM	#6
Teryl New Member Join Date: Feb 2002 Posts: 19	Thanks my Time Stamping problem is solved. Mark, thanks so much. I love this site.