+ Reply to Thread
Results 1 to 6 of 6

Stamping the current time

  1. #1
    Registered User
    Join Date
    06-13-2007
    Posts
    7

    Stamping the current time

    When cell B1 (for example) has text entered into it, I want cell A1 (for example) to display the time and date at which the text was added to B1. I want this to happen automatically.

    I tried
    Please Login or Register  to view this content.
    but that changes every time I open the document or click enter and so on. I need something stamps the time and then never changes.

    Any ideas?
    Last edited by 123456; 06-14-2007 at 03:06 PM.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This link should help

    http://www.mcgimpsey.com/excel/timestamp.html

    or you could try a function

    Please Login or Register  to view this content.
    or an event macro

    Please Login or Register  to view this content.

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    09-11-2006
    Posts
    56
    this is how I worked out the time stamp problem and I was directed by someone on here .

    this is in col A
    =IF(B2="","",IF(A2="",NOW(),A2))
    this is in col B
    =IF(C2="","",IF(B2="",NOW(),B2))

    basicly it works like this I have a drop down box in col c when I select a company from the drop down box col a is date stamped and col b is time stamped, this has been working for almost a year now.

    hope this helps
    "There are 10 kinds of people in the world, Those that understand binary, and those that don't."

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Lol lrhodes..it was me witht the same link

    http://www.excelforum.com/showthread.php?t=575660

    VBA Noob

  5. #5
    Registered User
    Join Date
    06-13-2007
    Posts
    7
    Thank you, it appears to be working. One more thing, is there a way of structuring the "ddd dd mm yy" thing to render as "Thu 14th Jun 07" instead of "Thu 14 Jun 07". If it's particularly complicated, I don't really need to know, it's not really that important. Thanks in advance.

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe

    =IF(B2="","",IF(A2="",TEXT(NOW(),"ddd dd")&CHOOSE(MOD(DAY(NOW()),10)+1,"th","st","nd","rd","th","th","th","th","th","th")&TEXT(NOW()," mmm yy"),""))

    VBA Noob

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1