excel Help

[Coldplay]

I am doing a timetable off people in a place. I need too do this timetable and a diagram with how many people that are at the place at the same time. i can do the table but the diagram i can´t....

The table can look like this....

Berit: Monday 08:00-17:00 Tuesday 7:00-15:30 Wednesday 9:00-16:00 Thursday 7:20-17:20 Friday 8:00-14:00

Sven: Monday 08:45-15:30 Tuesday 7:00-16:30 Wednesday 7:00-16:00 Thursday 8:20-17:20 Friday 8:00-16:00

Tor: Monday 7:00-12:15 Tuesday 7:00-14:30 Wednesday 8:30-16:00 Thursday 7:20-15:20 Friday 7:00-16:10

[Pecoflyer]

Hi

maybe post a sample sheet with what you have and what you need

[Coldplay]

This is just a test file but i can look like this but i have 42 people too keep track off. i want too know how many i have in the premises. The time i want too keep track off is 7 a clock, 8 a clock 9 a clock in the morning how many i have att lunch 11:30 and how many at the afternoon att 15:00, 16:00 and after 17:00

[Pecoflyer]

Does this help ? ( see attached)
Start and end time were placed in different columns