Looking to find duration at different levels

[petersw]

Hi,

My data is as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Level[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1/1/2015[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1/23/2015[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1/30/2015[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]2/5/2015[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]1/12/2015[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]1/15/2015[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to easily see how long each person was at a given level. For example, from the above, I see John was at level 1 for 22 days, at level 2 for 12 days. Bill was at level 1 for 3 days. Ideally I'd like to get this type of information into a format that can be graphed.

I'm thinking a pivot table will come into play, but I'm struggling and thought the brains at MrExcel could help!

Thanks,
Peter

 

[Oeldere]

Book1
	A	B	C	D	E	F	G	H
1	Name	Date	Level	days
2	John	1-1-2015	1	22		Rijlabels	Som van days
3	John	23-1-2015	2	7		Bill	3
4	John	30-1-2015	2	6		1	3
5	John	5-2-2015	3			2	0
6	Bill	12-1-2015	1	3		John	35
7	Bill	15-1-2015	2			1	22
8						2	13
9						3	0
10						Eindtotaal	38
11
Blad1

d2=if(A3=A2,B3-B2,"")