View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] janderson@sgt.co.uk is offline
external usenet poster
 
Posts: 2
Default Formula that will record the time and date when an entry is made on a sheet

Hi, is there a formula that will record the time and date that an
entry was made on a sheet. I am trying to make a telephone log that
will show me which customers called for which salesmen, so rather than
entering the time and date against each call entry I wondered if
there was a function that would record the time and date that a cell
was editted. Wondered if I could use the "=now()" function, but as
time passes the sheet simply updates! Any insights much appreciated -
John