how long it took for one stock sheet input

[makinmomb]

Formula on column E F and G to drag down

[ChemistB]

In E2 copied down

Please Login or Register  to view this content.

In F2 copied down

Please Login or Register  to view this content.

In G2 copied down
=F2-E2
Column G is formatted as custom [mm]:ss

[shg]

Row\Col	D	E	F	G
1		start	end	duration
2	EMP001	{=MIN(IF($B$1:$B$46=$D2, $A$1:$A$46))}	{=MAX(IF($B$1:$B$46=$D2, $A$1:$A$46))}	=F2-E2

Row\Col	D	E	F	G
1		start	end	duration
2	EMP001	12/17/2014 11:04:55	12/17/2014 11:14:49	0:09:54
3	EMP002	12/17/2014 11:15:22	12/17/2014 11:24:24	0:09:02
4	EMP003	12/17/2014 11:24:48	12/17/2014 11:32:23	0:07:35

[makinmomb]

Thank you Chemist B ,

I am exactly able to see who
did what work from 5000 rows pasted

SHG your formula nice too , but i picked
of CHEMIST B since its non array though
longer than yours

[shg]

That ChemistB is a smart guy ...

[ChemistB]

LOL, thanks. Now if I only understood handling statistics half as well as you, I'd be doing okay.