Time stamp in a cell 12

okeng · Nov 24, 2003

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 · Nov 24, 2003

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 · Nov 25, 2003

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 · Nov 25, 2003

Wow, how simple.

Absolutely perfect. Thanks a million.

Okeng

donf · Dec 29, 2003

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

Thanks (and a star) to Killswitch.

Donf

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Time stamp in a cell 12

okeng

Mechanical

Recommended for you

IRstuff

Aerospace

killswitch

Mechanical

okeng

Mechanical

donf

Chemical

Similar threads

Part and Inventory Search

Sponsor