+ Reply to Thread
Results 1 to 3 of 3

How to make Time Not Change when working with sheet

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Hamilton ON Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to make Time Not Change when working with sheet

    Hello everyone. I've created a delivery sheet to keep track of the Invoice No. Customer Name and time of delivery. I am having problems to solve the NOW() function. I first used this function and I thought it was great until I noticed that the time always changed to current time every time I used the work sheet which was every 10 to 15 minutes. Here is the formula I put together which is good if you want the current time =IF(A10=1,NOW(),"") HOWEVER what I need is when I type in " 1 " in A10 I want to show the current time in H10 but to hold that time and not change. Is this possible, any help would be great. Thank you all for now Carlo.

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: How to make Time Not Change when working with sheet

    Hi, Under Now() function time will change whenever excel recalculates or whenever you open or save the file, you cannot hold it under function.
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    Hamilton ON Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to make Time Not Change when working with sheet

    Thank you for your help. Is there any command line can use to hold the time so it does not change.

+ 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] Change a working shift to a time
    By smugglersblues in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2014, 11:44 AM
  2. Replies: 5
    Last Post: 05-28-2013, 01:04 PM
  3. trying to make a button on summary page to make new working sheet
    By dbzisme in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-07-2013, 05:41 PM
  4. Multiple pivots with the same row - how do i make them change at the same time?
    By davellll in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2009, 11:12 AM
  5. How do I make a change in time into a number I can use to calcula.
    By Sportystan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2005, 01:06 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