Re: Concurrent Calls With Start And End Time- How many?
Thanks for the reply. That formula does work but it shows the number of calls during a specific phone call. For example, using the formula given by bebbi, on line 54 it shows 102 calls being made during that start and end time. That tells me how many other calls were made during that 1 call which lasted 2 hours. It does not mean 102 calls were made at the same time. This is what im looking for instead. The calls being made at the same time. I can then show how many lines a phone system needs when people dial out on the same number.
Iv attached the sample spreadsheet with the formula to show you what i mean.