Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: NOW()-TODAY()

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Northampton, UK
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know what this formula does or shows?? "=NOW()-TODAY()"
    Thanx, B

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-28 08:06, Beckwa wrote:
    Does anyone know what this formula does or shows?? "=NOW()-TODAY()"
    Thanx, B
    I just answered in your original thread. Please do not start another thread on the same issue.
    =NOW()-TODAY() gives numeric expression for only time without the date function mixed with it.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Now() formula shows the current date and time. The Today() formula shows the current date. Therefore, the formula "=NOW()-TODAY()" shows the difference between the two, or the current time.
    It's never too late to learn something new.

    Ricky

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •