View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default if then statement = time

See

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

In article ,
jstaggs wrote:

How do you write an "if' statement that will result in the pc system time.

Ex. IF cell A10, populate A2 with the system time that cell A1 was
populated.