I'm looking for some help to take a series of status change dates made against a record and record the time that record was held in the respective status'.
I have attached a screen shot of a single Work Order record and have summarized the status change dates and sorted the dates in ascending order.
Is there a way to take the next status date in the series and "create a new row" that captures the next date in the time series to generate a date / time calculation?
For example, I want to see the time it took to go from WAPPR (2016-10-04) to WENG (2016-10-04) - ~24minutes. This would require me to pull in the change date of WENG to a NEW column next to the previous status of WAPPR - or so this is my mental model (image attached for reference).