Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Need help with formula

    hi all,

    what formula will give the delta in days between the down date and time figures, each in a separate column.

    No code has to be inserted here.
    TIA
    dubdub

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    If your start date is in cell [A1] and start time in cell [A2], your end date in cell [A3] and end time in [A4], then your difference in decimal days formula in cell [A5] is:
    =(A3+A4)-(A1+A2)
    ..and the answer for your example (assuming the second date is 02-Jul-2010) is 66.625 days

    zeddy

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Zeddy,

    that was the first thing i tried before posting the question, but i was getting -833, and i do not know why?
    TIA
    dubdub

  4. #4
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    follow up on my previous post, I just found the reason, it is the time format which was in text, after fixing that i was able to get 66.63, thanks for the inspiration.
    TIA
    dubdub

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi dubdub

    When I entered your sample data I automatically typed the 'colon' when entering the time values.
    I suppose I should have been more specific about the time format.
    So perhaps we are both guilty of simple oversight.
    Whenever I'm faced with an unexpected answer, I ask myself the question "What would Rod Stewart do?" and generally that give's me inspiration.

    zeddy

Posting Permissions

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