View Full Version : MS Excel problem

07-19-2007, 04: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.


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


07-20-2007, 09:16 AM

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


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