Function between 2 rows

[japturtle]

A B C D
4/1/11 10:00 12:00
4/1/11 13:00 18:00 8 hrs
4/2/11 10:00 14:00 4 hrs
4/3/11 10:00 12:30
4/3/11 13:00 17:30 7.5 hrs

How do I create a function to get the answers listed above in Column D?? Where Column D is the value of the start and stop times in one day?

 

[venkat1926]

in D2 repeat D2 (do not do anything in D1,leave it) copy this formula

=IF(AND(A2=A1,B2>=C1),C2-B1,IF(AND(A2<>A1,A2<>A3),C2-B2,""))
copy D2 down.

the result is like this

Excel Workbook
	A	B	C	D
1	4/1/2011	10:00	12:00
2	4/1/2011	13:00	18:00	8:00
3	4/2/2011	10:00	14:00	4:00
4	4/3/2011	10:00	12:30
5	4/3/2011	13:00	17:30	7:30
Sheet1

 

[japturtle]

Wonderful! Exactly what I needed. Thank you so much!