Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jul 2006
    Posts
    138
    Thanks
    3
    Thanked 0 Times in 0 Posts

    MS Excel problem

    Can anyone tell me how resolve this problem?

    9684 for 107447 by pas at Thu Jun 21 17:14:42 EDT 2007

    9684 by pas closed at Fri Jun 22 1:00:55 EDT 2007
    There are two rows and I am trying to subtract time from one to the other. The problem is I cannot just use simple subtraction because the dates are different. Now I thought of this formula in Excel but it gives error.

    =if(I1<>H2,((J1-24:00:00)+I2),I2-J1)

    where I1 & H2 are the date column and J1 & I2 are the time column for the two rows.

    Help!

  • #2
    New Coder
    Join Date
    Apr 2007
    Location
    India
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time subtraction

    Hi

    Let me know what's the error it showing.. so that we can change the formula or else follow the below formula

    Code:
    B2-A2+IF(A2>B2,1)
    Come back if you have any other solutions
    GemGuy

    Be friend of me
    Hey what a fun


  •  

    Posting Permissions

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