Subtraction of cells in alternating ranges

[irwin259]

Hello,

I am looking for a solution preferably with formulas or in vba.

Need something to be able to calculate the cycle times in column 8 below by subtracting the finish time from the start time for each cycle.
The cycles vary in cell row ranges so I'm not sure how to go about this. Thought of using count blanks formula but can't figure it out.
Help appreciated.

[/IMG]

 

[steve the fish]

Hi. Try this:

=IF(A2="finish",G2-LOOKUP(2,1/($A$2:A2="start"),$G$2:G2),"")

 

[irwin259]

Hi. Try this:

=IF(A2="finish",G2-LOOKUP(2,1/($A$2:A2="start"),$G$2:G2),"")

Hi,

Thanks but this is returning a #N/A error not sure what this means.

 

[steve the fish]

Which cell is the top left cell from that image?

 

[irwin259]

I see the problem now, works perfect thanks!