How do i refer the previous and next row and do the calculation

How do i refer the previous and next row and do the calculation, Staus_id = 2 = Start  Staus_id  = 3 = End I need a duration (End - Start ) by using ac_start_date.  I tried creating index and fill...