Time stamp in a cell
Time stamp in a cell
(OP)
I use an excel spreadsheet to log my time on various projects. Basically I "clock in" and "clock out".
It seems there should be an easy way to insert the current time and date in a cell. I can use NOW() or something like that, but it updates it. What I need is more of a timestamp function.
Thanks
It seems there should be an easy way to insert the current time and date in a cell. I can use NOW() or something like that, but it updates it. What I need is more of a timestamp function.
Thanks
RE: Time stamp in a cell
You can VBA it to automatically do that upon file close or file open as well.
TTFN
RE: Time stamp in a cell
Both are text values and won't update.
Killswitch
RE: Time stamp in a cell
Absolutely perfect. Thanks a million.
Okeng
RE: Time stamp in a cell
Thanks (and a star) to Killswitch.
Donf