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.

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.

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.