Function key to input current time

mwillis · Apr 10th, 2002, 07:00 AM

I updated start and end times for numerous events. Much time would be saved if I could tab to appropriate cell and press a function key that would then enter the current time. Once inputted need time to be static. Tried to utilize the =now() but it was dynamic, in that all start and end time reflect current time. Any suggestions on how to do this?

Dave Hawley · Apr 10th, 2002, 07:01 AM

Hi

How about:

Ctrl+Shift+:

mwillis · Apr 10th, 2002, 07:05 AM

Thanks Dave. One quick follow up anyway to set a function key to these values?

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

Apr 10th, 2002, 07:00 AM	#1
mwillis New Member Join Date: Apr 2002 Posts: 3	I updated start and end times for numerous events. Much time would be saved if I could tab to appropriate cell and press a function key that would then enter the current time. Once inputted need time to be static. Tried to utilize the =now() but it was dynamic, in that all start and end time reflect current time. Any suggestions on how to do this?

Apr 10th, 2002, 07:01 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi How about: Ctrl+Shift+:

Apr 10th, 2002, 07:05 AM	#3
mwillis New Member Join Date: Apr 2002 Posts: 3	Thanks Dave. One quick follow up anyway to set a function key to these values?