Calculate time difference with other rows

Hi,   I have a case tracking system that stores the date when a case passes from a state to another in a single row, then I want to calculate the duration time between state changes.   I have dat...