Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Automatically insert time stamp in adjacent cell when changing values

  1. #1
    Join Date
    6th January 2011
    Posts
    2

    Automatically insert time stamp in adjacent cell when changing values

    How can I have a cell (or series of cells) with a time stamp that won't change every time I enter data into other cells? I want to be able to put a date in [A1] and have a time show up in [B1]. Another date in [A2] with a new time stamp in [B2] without it changing the time in [B1] And so on. Any help would be appreciated.
    Last edited by AAE; January 6th, 2011 at 20:13. Reason: revise thread title

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th September 2004
    Location
    Australia
    Posts
    580

    Re: Time stamp

    Using a macro?

    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
         
        If Target.Column = 1 Then 
            ActiveCell.Offset(0, 1) = Format(Now(), "HH:MM:SS") 
        End If 
         
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    3rd August 2010
    Location
    Union City, Pa - USA
    Posts
    607

    Re: Time stamp

    Or for in cell use.

    =IF(A1 >0,NOW(),"")

    HTH
    The Only Dumb Question Is A Question Not Asked.

  4. #4
    Join Date
    6th September 2004
    Location
    Australia
    Posts
    580

    Re: Time stamp

    Yegar,
    That will change with every sheet calculation.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    3rd August 2010
    Location
    Union City, Pa - USA
    Posts
    607

    Re: Time stamp

    Ohh.....well i hadn't thought of that :/ good point. Just trying to help. But i did learn somthing new. Thanks Justin. Cheers
    The Only Dumb Question Is A Question Not Asked.

  6. #6
    Join Date
    6th January 2011
    Posts
    2

    Re: Time stamp

    That's the delima I've been having. Unforunately I need to brush up on macros and VB.....it's been a long time since I've used them. Thanks for everyones help.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    1st September 2010
    Posts
    7,756

    Re: Time stamp

    Assuming that Column B is just a timestamp column and contains no other information, and you only want to enter the system time when data is first entered in column A, slightly modifying Justins code gives...
    VB:
    Private Sub Worksheet_Change(ByVal Target As Range) 
        If Target.Column = 1 And Target.Offset(0, 1).Value = "" Then 
            Target.Offset(0, 1) = Format(Now(), "HH:MM:SS") 
        End If 
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Automatically insert time stamp in adjacent cell when changing values

    Hello Taybo,

    Welcome to Ozgrid. We're glad to have you here at Ozgrid, however, please note the following regarding thread titles.

    Thread titles are used in searching the forum, therefore, it is vital the be written to accurately describe your thread content or overall objective using ONLY search friendly key words.

    • The title must not use non-essential words such as:"Help needed", "Formula problem", "Please help", "urgent", "Code issue", "Need Advice", etc. Such words dilute the title/search results.
    • The title should not contain VBA code or formula syntax or use abbreviations, jargon, delimiters
    • The title should not assume or anticipate a solution as in referencing Excel functions or VBA methods - the actual solution is often quite different
    • The title must not consist of a single word description; such titles do not fully describe the thread


    Please note the change to your title, which is based on the objective stated in your thread.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Possible Answers

  1. PHP Date Time function and time stamp
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: July 10th, 2008, 02:27
  2. Time Stamp Entries
    By lvsaint in forum EXCEL HELP
    Replies: 5
    Last Post: August 14th, 2007, 23:46
  3. Date/time Stamp
    By karenjuniper in forum EXCEL HELP
    Replies: 2
    Last Post: June 23rd, 2006, 02:47
  4. Match then Time Stamp
    By eriond in forum EXCEL HELP
    Replies: 2
    Last Post: May 9th, 2006, 03:19
  5. Time stamp
    By grube386 in forum EXCEL HELP
    Replies: 7
    Last Post: May 5th, 2006, 20:18

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno