Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Time stamp in a cell

Time stamp in a cell

Time stamp in a cell

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.


RE: Time stamp in a cell

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.


RE: Time stamp in a cell

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.


RE: Time stamp in a cell

Wow, how simple.

Absolutely perfect.  Thanks a million.


RE: Time stamp in a cell

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

Thanks (and a star) to Killswitch.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close