Having the current time inserted w/o updating the current time
 

Does anyone know how I would put in the current time without having it update
on every save?

For example I have a formula where a time automatically gets inserted in a
cell, when another cell gets typed in.
Now if an hour passes I want to be able to keep that original time.
Does anyone know how? I am currently using an If statement with the "Now"
function, but it is not serving my purpose.

Thanks in advance.

Having the current time inserted w/o updating the current time
 

Hi sherobot

You can insert the time like this
CTRL : (colon)

The date like this
CTRL ; (semicolon)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"sherobot" wrote in message ...
Does anyone know how I would put in the current time without having it update
on every save?

For example I have a formula where a time automatically gets inserted in a
cell, when another cell gets typed in.
Now if an hour passes I want to be able to keep that original time.
Does anyone know how? I am currently using an If statement with the "Now"
function, but it is not serving my purpose.

Thanks in advance.

Having the current time inserted w/o updating the current time
 

You can use an event macro. Play with the below code to get the correct cell
to populate in your sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
[A1] = Now()
End Sub

--
Regards,
Dave


"sherobot" wrote:

Does anyone know how I would put in the current time without having it update
on every save?

For example I have a formula where a time automatically gets inserted in a
cell, when another cell gets typed in.
Now if an hour passes I want to be able to keep that original time.
Does anyone know how? I am currently using an If statement with the "Now"
function, but it is not serving my purpose.

Thanks in advance.