Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Current time (2002 XP)

    I need to display the current time in A1 and display the current time plus 15 minutes in B1. I have tried and failed many times so, despite my embarrassment, I am asking for help. Thank you in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Current time (2002 XP)

    Hi Don,

    In cell A1, enter the formula =NOW() and in cell B1, enter the formula =A1+TIME(0,15,0)
    Then, select A1 and B1, and use Format | Cells... to set the desired time format for these cells.

    The TIME function has syntax TIME(hours,minutes,seconds).

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Current time (2002 XP)

    Don

    Check this... http://www.erlandsendata.no/

    and see the attached file

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Current time (2002 XP)

    If you forget formulas and syntax, a very basic way is to use the excel date calculation principle, I mean that the excel date unit = one day.
    So if you want to display one hour, just type =1/24 then format / cell / number / time
    If you want to add 15 minutes to the current time, type =now()+(1/24/60*15)

    Quick and dirty but easy to remember...

Posting Permissions

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