Time stamp in a cell 12

[okeng]

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

 

[IRstuff]

You can place now() in a cell. Then copy that value with paste special to where you want to timestamp.

You can VBA it to automatically do that upon file close or file open as well.

TTFN

 

[killswitch]

In any cell, press 'Ctrl'+':' to get the current date and Shift'+'Ctrl'+':' for the current time.
Both are text values and won't update.

Killswitch

 

[okeng]

Wow, how simple.

Absolutely perfect. Thanks a million.

Okeng

 

[donf]

I was looking for the same thing, except I am using MS Access - AND IT WORKS.

Thanks (and a star) to Killswitch.

Donf