setting up excel to insert time of day

L

LookingGood

Is there a way to set up excel worksheet to automatically insert time in the
designated cell when clicking in the cell, this will help us to track time
for a project. This is to avoid the need to manually entering the time
 
H

Harlan Grove

Crossposted to microsoft.public.excel.misc

LookingGood said:
Is there a way to set up excel worksheet to automatically insert time in the
designated cell when clicking in the cell, this will help us to track time
for a project. This is to avoid the need to manually entering the time
Click to expand...

This isn't the ideal newsgroup in which to ask Excel-specific
questions. There are Excel newsgroups which would be much better
choices.

That said, you can enter the current time in Excel using the keyboard
shortcut

[Shift]+[Ctrl]+;

that is, hold down [Shift] and [Ctrl] keys (one of each sufficient,
you don't have to hold them all down) and press the ; key. Either
press [Enter] after this or add additional text.

Automatically entering anything into any cell merely upon selecting it
requires macros.
 
Top