I have this data on a worksheet

Name: vb.bmp Views: 167 Size: 461.1 KB

I want to be able to calculate the elapsed time per status change (i.e. from Open to the last Assigned To, from the last Assigned To to the last Pending Testing) which can be output on a new column, new worksheet, wherever as long as the output will look like this (this is in a new worksheet):

Name: vb2.bmp Views: 159 Size: 438.8 KB

I need a code since there may be a lot of records and I need to be able to do it with just a simple push of a button.

Help?