Thread
:
Current date and time for different log entries
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
Current date and time for different log entries
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.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom