Skip navigation

Create a conditional pop-up window/note

960 Views 22 Replies Latest reply: May 25, 2012 4:36 PM by 2Skip2 RSS
  • Wayne Contello Level 6 Level 6 (12,650 points)
    Currently Being Moderated
    May 23, 2012 8:11 AM (in response to 2Skip2)

    Barry already suggested to only way I know to get the current time into a cell.  Numbers is not designed to be a real database program so it it doesn't have a "timestamp".

  • Wayne Contello Level 6 Level 6 (12,650 points)
    Currently Being Moderated
    May 25, 2012 4:47 AM (in response to 2Skip2)

    2Skip2,

     

    strictly speaking when you copy a cell with NOW() in it an paste values you are saving a dat/time value:

     

    The NOW function returns the current date/time value from the system clock

     

    you will have to jump through hoops to use it in a calulation as the date portion is included.  Perhaps it is time for a new trhead focused on this new topic where you also provide some of the details regarding what you are trying to do.

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    May 25, 2012 11:50 AM (in response to 2Skip2)

    Hi Skip,

     

    I suggested pasting using Edit > Paste Values, which will paste the Date and Time value copied from the cell containing NOW().

     

    =TIMEVALUE(B2) extract the fraction of a 24 hour day represented by the Time part of the Date and Time value in cell B2. You may find that useable in your calculations.

     

    No time for detail at the moment.

     

    Regards,

    Barry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    May 25, 2012 2:15 PM (in response to 2Skip2)

    HI Skip,

     

    Here's an example.

     

    Cell A1 contains =NOW().

    Column B contains a series of Date and Time values copied from A1, then pasted into column B using Edit > Paste Values

    Column C contains =TIMEVALUE(B), and shows the Time portion of the Date and Time value in B as the fraction of a day that time (of day) represents. The Date part of the value is ignored.

    D3 contains the formula =C3-C$2  The formula is filled down to D5, and shows the difference in the time value in its row from the time value in C2.

    E3 does the same calculation as D3, but multiplies the result by 24*60 to produce the number of minutes represented by that time value. E3: =(C3-C$2)*24*60

    F3 does the same calculation as D3, but multiplies the result by 24*60*60 to produce the number of seconds represented by that time value. F3: =(C3-C$2)*24*60*60

    Picture 8.png

     

    Below: Same table with column B formatted as Date and Time, Date: none, Time: 7:08 PM, and with another NOW() valued copied from A1 and placed in B7 using Paste Values:

    Picture 9.png

    Note that the NOW() value that was copied is what was pasted. The recalculation forced by drgging the formulas down to the next row included an update to NOW().

     

    Regards,


    Barry

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.