PDA

View Full Version : [SOLVED] Nested Statement Help for Time Calculation.



LutonBarry
09-24-2015, 03:24 PM
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.

SamT
09-24-2015, 04:03 PM
E2 Formula = "=IF(A2=A1,IF(C2>=D1,D2-C2,D2-D1),D2-C2)"
Copy down

LutonBarry
09-26-2015, 04:49 PM
Sam thanks very much worked a treat.