neo_philiac
07-19-2007, 03:46 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!
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!