Hello,
I was curious if there is any way to have time automatically tracked in excel. I will have a few colums, first will be the time, second will be notes, when a note is inputed is there a function available to automatically fill in the time? Please let me know, thank you.
Last edited by curtjer; 03-27-2009 at 02:20 PM.
you could try and google or search this forum for "time stamp", but the solution will involve some VBA programming.
Another way can be to educate your users to hit CTRL+Shift+; (semicolon), which will enter the time. CTRL+semicolon will enter the date.
I had a friend show me how to set this up.
=IF(D2<>"",IF(A2="",NOW(),A2),"")
Whenever I type into field D2 it populates current date and time in field A2 and down the A column as I write into current D columns. The next step I would like to do in which he was able to figure out so far is how to lock in the date and time after something has been typed into D2. If I make any changes to the D2 field it updates the date and time. Please let me know if anyone has a solution for this part. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks