Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Current time

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi guys,

    This is probably a simple question, but I havent been able to find the function to insert.

    I need a cell to display the current time, to seconds, based on the system clock. Then in another cell, take a certain number of hours off (or added to) this time, to provide the correct time in another timezone.

    I searched through previous posts but was unable to find what I am after.

    Thankyou for your help.

    [ This Message was edited by: chrissy on 2002-04-04 18:18 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =now() format cell as time to show secs.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanking you Paul B.

    Works a treat!

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry Guys,

    I know this is a major no-no, to post a question and then add another part to the problem, but here I go. Forgive me.

    How can I work out how many hours until a time the following day? For example, if the time is 9:00 p.m. and I want to know how many hours it is until 6:00 p.m. tomorrow. I cant seem to work out how to not arrive at the answer 3! I have tried adding a day, but when the current time is 1:00 a.m. using this method will be incorrect.

    Thankyou again guys.

  5. #5
    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-04 19:00, chrissy wrote:
    Sorry Guys,

    I know this is a major no-no, to post a question and then add another part to the problem, but here I go. Forgive me.

    How can I work out how many hours until a time the following day? For example, if the time is 9:00 p.m. and I want to know how many hours it is until 6:00 p.m. tomorrow. I cant seem to work out how to not arrive at the answer 3! I have tried adding a day, but when the current time is 1:00 a.m. using this method will be incorrect.

    Thankyou again guys.
    Hi Chrissy:

    in cell E10 ... 4/4/02 9:00 pm
    in cell F10 ... 4/5/02 6:00 pm

    then in cell G10, put the formula =F10-E10

    and FORMAT|CELLS|CUSTOM [h:mm:ss
    result should be 21:00:00

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

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
  •