Looking to find duration at different levels

[petersw]

Hi,

My data is as follows:

Name	Date	Level
John	1/1/2015	1
John	1/23/2015	2
John	1/30/2015	2
John	2/5/2015	3
Bill	1/12/2015	1
Bill	1/15/2015	2

<tbody>
</tbody>

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,"")