I have created a log that my employees are using to input data every hour or
so and instead of having them input date and time, I would like to have excel
do it automatically. I understand how the NOW() and TODAY() functions work.
However, with either of those functions, they automatically update everytime
an entry is made. Once the date and time in formulated, it needs to stay at
that date and time. I've been trying to figure this out for two weeks now.
If anyone has a suggestion, please let me know. Thanks.

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


--


Regards,


Peo Sjoblom



"SBO Refiner" <SBO wrote in message
...
I have created a log that my employees are using to input data every hour
or
so and instead of having them input date and time, I would like to have
excel
do it automatically. I understand how the NOW() and TODAY() functions
work.
However, with either of those functions, they automatically update
everytime
an entry is made. Once the date and time in formulated, it needs to stay
at
that date and time. I've been trying to figure this out for two weeks
now.
If anyone has a suggestion, please let me know. Thanks.

That would take VBA code. If that is what you are after, post back with
specifics about your sheet layout and someone will help.

Vaya con Dios,
Chuck, CABGx3



"SBO Refiner" wrote:

I have created a log that my employees are using to input data every hour or
so and instead of having them input date and time, I would like to have excel
do it automatically. I understand how the NOW() and TODAY() functions work.
However, with either of those functions, they automatically update everytime
an entry is made. Once the date and time in formulated, it needs to stay at
that date and time. I've been trying to figure this out for two weeks now.
If anyone has a suggestion, please let me know. Thanks.

This can be done through code, here is a quick example:
If ActiveCell.Column = 1 Then
ActiveCell.Offset(0, 1) = Now()
End If

just put that in the type of event you want and you are good to go. I like
before double-click but use what you want.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"SBO Refiner" wrote:

I have created a log that my employees are using to input data every hour or
so and instead of having them input date and time, I would like to have excel
do it automatically. I understand how the NOW() and TODAY() functions work.
However, with either of those functions, they automatically update everytime
an entry is made. Once the date and time in formulated, it needs to stay at
that date and time. I've been trying to figure this out for two weeks now.
If anyone has a suggestion, please let me know. Thanks.

Control semi-colon for date
Control shift colon for time
Control semi-colon / Space/ Control shift colon for date and time.
--
David Biddulph

"SBO Refiner" <SBO wrote in message
...
I have created a log that my employees are using to input data every hour
or
so and instead of having them input date and time, I would like to have
excel
do it automatically. I understand how the NOW() and TODAY() functions
work.
However, with either of those functions, they automatically update
everytime
an entry is made. Once the date and time in formulated, it needs to stay
at
that date and time. I've been trying to figure this out for two weeks
now.
If anyone has a suggestion, please let me know. Thanks.