Current date and time for different log entries
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. |
Current date and time for different log entries
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. |
Current date and time for different log entries
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. |
Current date and time for different log entries
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. |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com