LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last data entry made time and Date show in each worksheet Rajat Excel Worksheet Functions 3 November 12th 06 01:27 PM
How do I lock a stamp date/time formula for an entry on a row? PROPERTIES INC. Excel Worksheet Functions 3 August 4th 06 12:45 AM
After a date entry is made, only displaying the Day Alec H Excel Discussion (Misc queries) 3 February 9th 06 01:10 PM
Macro to record user name and date/time Maddoktor Excel Discussion (Misc queries) 0 December 8th 05 10:03 PM
time-sheet record with over 24 hours kkwaters New Users to Excel 2 December 16th 04 06:24 AM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"