Calculation of time difference

[balrammahato204]

Hello Guys, please help me i got stuck in one problem:-

I want to calculate the Total time difference from Assigned status to last In Progress status.

But there is a condition if there is a any Pending status in the column and then after just there is a first in progress status, time difference should be exclude. Eventually, what would be the final time difference.

Hers is a scenario:

ID NO	Date	Status
ID001	3/20/2015  6:43:25 AM	Assigned
ID001	3/20/2015  6:46:56 AM	In Progress
ID001	3/20/2015  6:52:13 AM	Pending
ID001	3/23/2015  2:42:26 AM	In progress
ID001	3/23/2015  2:42:29 AM	In progress
ID001	3/24/2015  2:15:23 AM	Pending
ID001	3/27/2015  9:15:23 AM	Pending
ID001	3/28/2015  9:15:23 AM	In Progress

[balrammahato204]

Hi Swuehl,

At first i want to say thank you very much for your solution. My last query for this calculation. I have already post in the previous reply.So could you please check once.

Regards

Balram