Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.office.misc,microsoft.public.excel.misc
|
|||
|
|||
setting up excel to insert time of day
Crossposted to microsoft.public.excel.misc
LookingGood wrote... 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to insert time of day in excel cell | Excel Discussion (Misc queries) | |||
Excel: How to insert current time (static) to the nearest second? | Excel Worksheet Functions | |||
how do i insert a real time clock in excel ? | Excel Discussion (Misc queries) | |||
insert running time on excel | New Users to Excel | |||
automatically insert date and time into excel] | Excel Discussion (Misc queries) |