How to have excel work out time difference if case numbers are a duplicate

[masterexcelbundle]

Hi, I am trying to work out how long it takes a consultant to complete a case.
What I am hoping to do is, if the case number in column F are the same (duplicated circled in red) then we would work out the difference between the same rows in column D.
I.e. Case number 07313411 as rows F5&F6 match in column F, then the formula would read cells D5&D6 and produce the time difference of 3 minutes (1:05pm to 1:09pm).
There are some times when there are 3 lines of the same case number and they cross over midnight, so have two separate dates.

Thankyou in advance

 

[Toadstool]

Hi MasterExcelBundle,

Does this do what you want?

MasterExcelBundle.xlsx
	A	B	C	D	E	F	G
1	Old Value	New Value	Field/Event	Edit Date	Edited By	Case Number	Elapsed Minutes
2	One	Two	S	09-Feb-22 02:53	Nm	123
3	One	Two	S	09-Feb-22 01:09	Nm	234
4	One	Two	S	09-Feb-22 01:10	Nm	234	1
5	One	Two	S	09-Feb-22 01:05	Nm	456
6	One	Two	S	09-Feb-22 01:09	Nm	456	4
7	One	Two	S	09-Feb-22 02:37	Nm	567
8	One	Two	S	09-Feb-22 02:38	Nm	567
9	One	Two	S	09-Feb-22 02:53	Nm	567	16
10	One	Two	S	09-Feb-22 02:53	Nm	789
11	One	Two	S	09-Feb-22 12:53	Nm	789
12	One	Two	S	10-Feb-22 01:00	Nm	789	1327
13
Sheet1

Cell Formulas
Range	Formula
G2:G13	G2	=IF(AND(COUNTIF($F$2:$F$9999,F2)>1,COUNTIF($F$2:$F$9999,F2)=COUNTIF($F$2:$F2,F2)),ROUND((D2-INDEX($D$2:$D$9999,MATCH(F2,$F$2:$F$9999,0)))*1440,0),"")

 

[masterexcelbundle]

that did work, thankyou so much

 

[Toadstool]

that did work, thankyou so much

You're welcome.
Thanks for the feedback.