On 18 May, 09:53, PauloG wrote:
Hi,

I work in a small office with 4 people and need to produce a graph which
shows when we have more than 1 person on the phone at the same time. The

I then need to show this information with the date on the x axis and the
amount of people on the phone at the same time on the y axis.


Your question is vague, and I'm not sure if you need to know:

a. the maximum number of people on the phone at once at any time
during each day
b. the number of people on the phone at a time, during the day.

I'm assuming the second one, which I think is more useful.

From your data, decide how often you want to check how many people are
on the phone at once, and put all these times down in a worksheet.

e.g.

10:00:00
10:05:00
10:10:00
....

against each one, use a formula like this:

=SUMPRODUCT(($D$15:$D$22<C25)*1,($E$15:$E$22C25)* 1)

where.............
C25 is the time you are checking e.g. 10:00:00
D15:D22 is the list of start times
E15:E22 is the list of end times

This will give you a count of how many people were on the phone at
that time. Actually, how many calls were in progress (ie started, but
not finished) at that time.

Copy the formula to cover each of your "sample" times.

Build a graph from these sample sets.

HTH

Andrew