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

Thread: Date Formula

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

    Default

    Hi There,
    I was wondering how to calc this date formula.
    3/30/02 9:30 AM + 8.5(Hours)
    So I want it to display the answer like
    3/30/02 6:00 PM
    Any suggestions on how to setup this formula.
    Please help!

    Thanks


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-09 09:00, soto wrote:
    Hi There,
    I was wondering how to calc this date formula.
    3/30/02 9:30 AM + 8.5(Hours)
    So I want it to display the answer like
    3/30/02 6:00 PM
    Any suggestions on how to setup this formula.
    Please help!

    Thanks
    In C1 enter:

    =A1+B1/24

    where A1 houses a value like 3/30/02 9:30 AM and B1 a value like 8.5, which is a decimal time.

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

    Default

    On 2002-04-09 09:19, Aladin Akyurek wrote:
    On 2002-04-09 09:00, soto wrote:
    Hi There,
    I was wondering how to calc this date formula.
    3/30/02 9:30 AM + 8.5(Hours)
    So I want it to display the answer like
    3/30/02 6:00 PM
    Any suggestions on how to setup this formula.
    Please help!

    Thanks
    In C1 enter:

    =A1+B1/24

    where A1 houses a value like 3/30/02 9:30 AM and B1 a value like 8.5, which is a decimal time.
    Thanks for responding but that formula did not work for me.
    I think i understand the formula but "B1 a value like 8.5, which is a decimal time" in my B1 cell has to display the same as A1. What do you mean by decimal time.

    Thanks

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-09 09:34, soto wrote:
    On 2002-04-09 09:19, Aladin Akyurek wrote:
    On 2002-04-09 09:00, soto wrote:
    Hi There,
    I was wondering how to calc this date formula.
    3/30/02 9:30 AM + 8.5(Hours)
    So I want it to display the answer like
    3/30/02 6:00 PM
    Any suggestions on how to setup this formula.
    Please help!

    Thanks
    In C1 enter:

    =A1+B1/24

    where A1 houses a value like 3/30/02 9:30 AM and B1 a value like 8.5, which is a decimal time.
    Thanks for responding but that formula did not work for me.
    I think i understand the formula but "B1 a value like 8.5, which is a decimal time" in my B1 cell has to display the same as A1. What do you mean by decimal time.

    Thanks
    When 8:30 is rendered as 8.5, it's called decimal time.

    The formula I suggested should work if A1 is date-formatted. The cell of the formula (C1) must be formatted like A1.

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
  •