+ Reply to Thread
Results 1 to 7 of 7

Fixing Formula NOW()

  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    Costa Rica
    MS-Off Ver
    MS Excel 2013 / 32 bits
    Posts
    14

    Cool Fixing Formula NOW()

    Hi Everyone,

    i'm working on a specialized tracker for audits and in order to verify how much time does the person auditing is taking to get it done i need to create a formula to leave a timestamp.
    i've used Now() formula but it works for the first record however when i fill out a second line it will change the actual line and also the ones above or if i ever update any cell in the spreadsheet it will change all the timestamps to the actual date/time.i need to fix it so i can record the information i need. I've read many posts saying that i need to get into VBA codes. i'll attach the file. need help please!

    please let me know if there is a formula i can use or trick to fix the result?

    or if need to go into VBA could you please help?

    thank you sooooo much!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-15-2016
    Location
    here, there
    MS-Off Ver
    2010
    Posts
    59

    Re: Fixing Formula NOW()

    There is really only two options. One is using VBA which will do it automatically, The other is teaching the shortcuts. For current date use Ctrl+; for current time use Ctrl+Shift+;. In order to help with teaching that you could put an input message into the cell. The Input Message can be found by going to the "Data" tab, then "Data Validation", then "Input Message". What an input message does is when ever theat cell is selected a message appears next to the cell.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Fixing Formula NOW()

    NOW() and DATE() will update with any and every workbook change. You could set calcs to manual and set iterations to stop the update temporarily, but when you save/open/close the file, it will update, no matter what. As pointed out above, those are really the only permanent ways to do this
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    05-20-2016
    Location
    Costa Rica
    MS-Off Ver
    MS Excel 2013 / 32 bits
    Posts
    14

    Re: Fixing Formula NOW()

    ok i see... is there a way you guys can help me to build this VBA code? thank you so much..

  5. #5
    Registered User
    Join Date
    06-15-2016
    Location
    here, there
    MS-Off Ver
    2010
    Posts
    59

    Re: Fixing Formula NOW()

    Here is a website that allows you to do this with formulas if you change some options in excell. http://www.howtoexcelatexcel.com/exc...with-formulas/
    Here is their vba explanation. http://www.howtoexcelatexcel.com/vba...xcel-with-vba/

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Fixing Formula NOW()

    crushdrinker06 your formula link is exactly what I said in post 3 - while it will work, it is only a temp fix, and can easily be "undone"

  7. #7
    Registered User
    Join Date
    06-15-2016
    Location
    here, there
    MS-Off Ver
    2010
    Posts
    59

    Re: Fixing Formula NOW()

    I do apoligize. I appreciate you pointing that out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help me fixing my excel formula...
    By amein in forum Excel General
    Replies: 18
    Last Post: 09-07-2015, 09:38 PM
  2. [SOLVED] Help Fixing A Formula
    By artiststevens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-21-2015, 03:12 AM
  3. [SOLVED] Need help in fixing my formula
    By rojashan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2014, 12:08 AM
  4. Fixing a Formula
    By Uvuriel03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2013, 08:43 AM
  5. Help Fixing IF/AND Formula
    By artiststevens in forum Excel General
    Replies: 22
    Last Post: 03-02-2012, 06:14 PM
  6. Fixing Part of a Formula
    By Daniel1234 in forum Excel General
    Replies: 2
    Last Post: 03-30-2010, 10:18 AM
  7. Fixing a formula
    By Boethius1 in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 07:38 PM

Tags for this Thread

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