Folks I hope you can help. I receive daily data dumps of Call data, that I need to calculate the total activity time for but making allowance where Activity times over lap so we do not double count and allowing for gaps between a previous activity end time and the start of the next. In the example the total actvity time in minutes should be 270 for call 1 and 120 minutes for call 2.
So I need the formula to check in column A the call number is the same and calculate and if not start afresh with a new calculation.
I have entered a basic If statement that works for some but not all of it.
