Non-volitile Timestamp

ozone64 · Apr 22nd, 2002, 06:43 PM

Ok, here's the skinny. I have a worksheet that is 5 columns wide. The first 2 columns are where the user will be entering data. the next 3 will contain a beginning timestamp, an ending timestamp, and a TOTAL time. The TOTAL time is pretty simple, but I am having a problem getting the time not to recalculate when I enter more data. Any help will be great. Thanks in advance....

Yogi Anand · Apr 22nd, 2002, 06:52 PM

You can enter the current time with

CTL+SHIFT+: and this will remain static!

ozone64 · Apr 23rd, 2002, 01:49 AM

One thing I forgot to add here. I need eg. A3 to have the timestamp automatically entered as soon as A1 & A2 get data entered into them. Sorry for the confusion!!!!

Tom Schreiner · Apr 23rd, 2002, 01:58 AM

Hi Ozone.
You could easily use the change event to stamp the current time into any cell...
O do not know which code example to give because your initial post speaks of columns, while your most current post, rows...

When and where do you need the beginning and ending time stamps?
Based upon which cells needing to have data?

Or E-Mail the sheet TsTom@Hotmail.com

Thanks,
Tom

[ This Message was edited by: TsTom on 2002-04-23 00:59 ]

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

Apr 22nd, 2002, 06:43 PM	#1
ozone64 New Member Join Date: Apr 2002 Posts: 3	Ok, here's the skinny. I have a worksheet that is 5 columns wide. The first 2 columns are where the user will be entering data. the next 3 will contain a beginning timestamp, an ending timestamp, and a TOTAL time. The TOTAL time is pretty simple, but I am having a problem getting the time not to recalculate when I enter more data. Any help will be great. Thanks in advance....

Apr 22nd, 2002, 06:52 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	You can enter the current time with CTL+SHIFT+: and this will remain static!

Apr 23rd, 2002, 01:49 AM	#3
ozone64 New Member Join Date: Apr 2002 Posts: 3	One thing I forgot to add here. I need eg. A3 to have the timestamp automatically entered as soon as A1 & A2 get data entered into them. Sorry for the confusion!!!!

Apr 23rd, 2002, 01:58 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Ozone. You could easily use the change event to stamp the current time into any cell... O do not know which code example to give because your initial post speaks of columns, while your most current post, rows... When and where do you need the beginning and ending time stamps? Based upon which cells needing to have data? Or E-Mail the sheet TsTom@Hotmail.com Thanks, Tom [ This Message was edited by: TsTom on 2002-04-23 00:59 ]