Thread: Current Time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Current Time

=IF(A10,NOW(),0)
that will put the current time if a value of 0 is entered
it will be a funny number, if you format the cell Time it will be a time


"ub" wrote:

Hi

What I want to do is that if I enter a value in a cell (Ex A1), in cell A2,
I want the current system time to automatically stamp and save it.
Please advise if this is possible.

Thanks