=NOW()

  • Thread starter Thread starter Alexis Pinington
  • Start date Start date
A

Alexis Pinington

I am trying to use this in each cell of column b of a
worksheet as part of the following formula - =IF
(C6="","",NOW()) this does generate the date and time
when information is entered in cell c6. However when I
enter information in any other cell, it reruns the NOW,
giving a new time for each update. Is there any way to
capture the time, without this changing once it has been
captured???
<p>
Thanks
 
Alexis said:
I am trying to use this in each cell of column b of a
worksheet as part of the following formula - =IF
(C6="","",NOW()) this does generate the date and time
when information is entered in cell c6. However when I
enter information in any other cell, it reruns the NOW,
giving a new time for each update. Is there any way to
capture the time, without this changing once it has been
captured???
<p>
Thanks
Click to expand...

Hi Alexis
have a look at
http://www.mcgimpsey.com/excel/timestamp.html
for creating a timestamp/datestamp. you may use the worksheet_change
procedure for your issue

Frank
 
Hi

The built-in shortcut for this is Ctrl+;
To insert the current time Ctrl+:
 
Thanks Arvi, but how do I automate this so that when data
is input in a cell (say B2), the current time (at the time
data is entered in b2) gets input in A2??

I am using the following to make the above work -

=IF(B2="","",NOW())

Using the IF statement works but it seems that when i
enter information in any cell using the if statement, the
time then changes again. Sorry if my explanation is not
brilliant - neither is my knowledge no the subject!!
 
Back
Top