Formula/Array Calculation help

[Fanwood]

I want to find the time it took to change from one status to another for a file. I want to know the duration between the status “Pending Vendor Onboarding” and”Action required” for file number 71845 using datetimestamp. I’ve tried to do it with an array but it’s just not working.


column A: FileNumber
Column C: Status
Column D: Datetimestamp

 

[NeonRedSharpie]

Are you looking for VBA to autopopulate the time it takes to change? Are you looking for a formula? Are the dats and times stored somewhere? I don't see the entire specs.

 

[Fanwood]

I tried to put the excel data in and it wouldn't let me. Having trouble with this site. VBA or some sort of array formula would work. sorry its a mess but its the only way I am able to get this data in. And it would actually be for ay matching file number

FileNumber ClientName StatusHistoryStatus DateTimeStamp
71845 Lp Action Required 6/25/2014 9:25
5646656 Lp Working 6/25/2014 10:36
71845 Lp Pending Vendor Onboarding 6/1/2014 6:00
453453 Lp Accepted by Vendor with Conditions 6/25/2014 14:01
434 Lp Accepted by Vendor with Conditions 6/30/2014 14:11
71845 Lp Pending Vendor Onboarding 7/7/2014 10:16
71845 Lp Accepted by Vendor with Conditions 7/7/2014 11:52