If IDs match in a column, then subtract date ranges formula needed

[trankim]

Hi,
I am hoping that someone can help me calculate to see if there's an identical match in column A, then to subtract the latest date from the earliest date (in days). There are instances where some IDs have the same date and time stamp (which is an anomaly) but I am not sure how to flag those scenarios. There's not that many scenarios where we would have "3 or more that" match with the exact times, and I can delete those manually if need be. However, the first question would be to just subtract the two dates if the IDs match.

Example is for the first ID "58110594", the end result would be 171 days
[TABLE="width: 285"]
<tbody>[TR]
[TD]58110594[/TD]
[TD="align: right"]9/17/11 2:49 AM[/TD]
[/TR]
[TR]
[TD]58110594[/TD]
[TD="align: right"]3/6/12 1:13 AM[/TD]
[/TR]
[TR]
[TD]642624883[/TD]
[TD="align: right"]2/8/12 1:36 AM[/TD]
[/TR]
[TR]
[TD]642624883[/TD]
[TD="align: right"]3/7/12 12:06 AM[/TD]
[/TR]
[TR]
[TD]642624883[/TD]
[TD="align: right"]2/8/12 1:36 AM[/TD]
[/TR]
[TR]
[TD]352182[/TD]
[TD="align: right"]12/29/11 3:38AM[/TD]
[/TR]
[TR]
[TD]352182[/TD]
[TD="align: right"]5/3/12 9:21 AM[/TD]
[/TR]
[TR]
[TD]800934[/TD]
[TD="align: right"]3/20/12 3:08 AM[/TD]
[/TR]
[TR]
[TD]800934[/TD]
[TD="align: right"]3/20/12 3:08 AM[/TD]
[/TR]
[TR]
[TD]927753[/TD]
[TD="align: right"]7/2/12 11:06 AM[/TD]
[/TR]
[TR]
[TD]927753[/TD]
[TD="align: right"]5/14/12 3:57 PM[/TD]
[/TR]
[TR]
[TD]927753[/TD]
[TD="align: right"]8/15/12 3:47 PM[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[texasalynn]

try this

Excel 2003
	A	B	C
1	58110594	9/17/2011 2:49
2	58110594	3/6/2012 1:13	171
3	642624883	2/8/2012 1:36
4	642624883	3/7/2012 0:06	28
5	642624883	2/8/2012 1:36	-28
6	352182	12/29/2011 3:38
7	352182	5/3/2012 9:21	126
8	800934	3/20/2012 3:08
9	800934	3/20/2012 3:08	0
10	927753	7/2/2012 11:06
11	927753	5/14/2012 15:57	-49
12	927753	8/15/2012 15:47	93
Sheet3

Cell Formulas
Range	Formula
C2	=IF(A2=A1,B2-B1,"")

 

[trankim]

thanks....question, the problem that I have would be if the IDs are not in order. could we have a formula that looks at matching IDs.....