View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Irmatwit Irmatwit is offline
external usenet poster
 
Posts: 1
Default 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