Formula Assistance

[DarrenF]

I have 2 columns of time stamps that track when a case owner changes hands and would like to pull the last time stamp when the case was closed (In Bold - column E) and subtract it from the time the case was opened (In Bold - column C). Is it possible to search the first time for case # 12806301 appears and return it to a cell and search for the last time for case # 12806301 and subtract it to see how long the ticket was opened for?

[TABLE="width: 720"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]12806301[/TD]
[TD]10/1/2018 6:27[/TD]
[TD]Inbound Queue[/TD]
[TD]10/1/2018 6:47[/TD]
[TD]Virginia Mason[/TD]
[/TR]
[TR]
[TD]12806301[/TD]
[TD]10/1/2018 6:47[/TD]
[TD]Virginia Mason[/TD]
[TD]10/1/2018 9:31[/TD]
[TD]Tech Queue[/TD]
[/TR]
[TR]
[TD]12806301[/TD]
[TD]10/1/2018 9:31[/TD]
[TD]Tech Queue[/TD]
[TD]10/1/2018 10:10[/TD]
[TD]Jimmy Johns[/TD]
[/TR]
[TR]
[TD]12806301[/TD]
[TD]10/1/2018 10:10[/TD]
[TD]Jimmy Johns[/TD]
[TD]10/2/2018 9:28[/TD]
[TD]Jimmy Johns[/TD]
[/TR]
</tbody>[/TABLE]

 

[Dave Patton]

Excel 2010
	B	C	D	E	F	G	H
1
2	12806301	10-01-18 6:27	Inbound Queue	10-01-18 6:47	Virginia Mason	10-01-18 6:27	10-02-18 9:28
3	12806301	10-01-18 6:47	Virginia Mason	10-01-18 9:31	Tech Queue
4	12806301	10-01-18 9:31	Tech Queue	10-01-18 10:10	Jimmy Johns
5	12806301	10-01-18 10:10	Jimmy Johns	10-02-18 9:28	Jimmy Johns
6	12806322	10-01-18 10:10	Jimmy Johns	10-02-18 10:28	Jimmy Johns
3e

Cell Formulas
Range	Formula
G2	=AGGREGATE(15,6,$C$2:$C$12/($B$2:$B$12=B2),1)
H2	=AGGREGATE(14,6,$E$2:$E$12/($B$2:$B$12=B2),1)