Current date and time for different log entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Control semi-colon for date
Control shift colon for time
Control semi-colon / Space/ Control shift colon for date and time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically entering time and date to an entry 2
Excel Concatenate Form Name to Parse for function 1
Data Entry date/time? 2
Date/Time issue with Pivot Table 3
Datedif function 1
how can i display the date and time of a cell entry in excel? 3
If cell is blank automatically enter today's date in the same cell 21
Access General Date Forced To Have Date And Time 2

Back
Top