I have a spreadsheet that contains call start dates and call end dates. Im trying to figure out how I can figure out that maximum # of calls that occur simultaneously through out the month. I've created another column that lists every date/time, each of the following one increasing by a minute. I've tried a couple of different formulas, but I just cant figure it out.
In the end, I need to know what the maximum # of simultaneous calls that occur during the month. I put my interval at a minute to get accurate results.