I needed to create a spreadsheet for a phone log for my company. What it
needs to do is when a long distance call is entered in, well say column B.
Then the date and time the call was made needs to appear in column A. I've
tried several different approaches but none work.

Thanks for your help,
Greg

Take a look at

http://www.mcgimpsey.com/excel/timestamp.html

BTW - saying you've tried several different approaches but none work
isn't particularly helpful - *what* methods did you try, and what didn't
work?


In article ,
"Greg" wrote:

I needed to create a spreadsheet for a phone log for my company. What it
needs to do is when a long distance call is entered in, well say column B.
Then the date and time the call was made needs to appear in column A. I've
tried several different approaches but none work.

Thanks for your help,
Greg