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?

B	C	D	E	F
12806301	10/1/2018 6:27	Inbound Queue	10/1/2018 6:47	Virginia Mason
12806301	10/1/2018 6:47	Virginia Mason	10/1/2018 9:31	Tech Queue
12806301	10/1/2018 9:31	Tech Queue	10/1/2018 10:10	Jimmy Johns
12806301	10/1/2018 10:10	Jimmy Johns	10/2/2018 9:28	Jimmy Johns

<colgroup><col span="5"></colgroup><tbody>
</tbody>

 

[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)