| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to show time that data was entered on spreadsheet
I want to know if its possible for the time to automatically appear in a
seperate cell when data is entered in a cell. For example, in cell A1 i enter the figure 3, in cell A2 the time i entered that number appears as hh.mm.ss. In cell B1 i enter the figure 4 & in cell B2 the time appears again in hh.mm.ss. Is this possible and how do i achieve it please. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I record the time data is entered into a spreadsheet? | Excel Worksheet Functions | |||
| Show a time 50 min before entered time | Excel Discussion (Misc queries) | |||
| Show zero values only when data is entered in other fields | Excel Discussion (Misc queries) | |||
| Show time stamp when a value is entered | Excel Discussion (Misc queries) | |||
| Formula does not show as I entered it. | Excel Worksheet Functions | |||
Threaded Mode
