...

View Full Version : MS Excel problem



neo_philiac
07-19-2007, 05:44 PM
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!

gemguy
07-20-2007, 10:16 AM
Hi

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


B2-A2+IF(A2>B2,1)

Come back if you have any other solutions:D :D



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum