+ Reply to Thread
Results 1 to 2 of 2

NOW() function

  1. #1
    Sami Euren
    Guest

    NOW() function

    If =now() fuction is used in a cell, and cell is formatted dd.mm.yy hh:mm,
    time is updated every time sheet is calculated. Like this you have exact
    information, when latest change was done. Problem is, that it changes the
    time every time sheet is opened also, and data is "lost". What would be the
    easiest way to save the latest time when change to sheet was done ? Is it a
    function button, that copies only the time value to another cell or what ?

    -Sami



  2. #2
    JE McGimpsey
    Guest

    Re: NOW() function

    Take a look here:

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

    In article <[email protected]>,
    "Sami Euren" <[email protected]> wrote:

    > If =now() fuction is used in a cell, and cell is formatted dd.mm.yy hh:mm,
    > time is updated every time sheet is calculated. Like this you have exact
    > information, when latest change was done. Problem is, that it changes the
    > time every time sheet is opened also, and data is "lost". What would be the
    > easiest way to save the latest time when change to sheet was done ? Is it a
    > function button, that copies only the time value to another cell or what ?
    >
    > -Sami


+ 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