I have two lists of time, one a set of starts and the other a set of ends, I want to calculate the duration between them and sum them.
When the end time goes past midnight, I experience a problem. I can calculate the difference between the times correctly, but the sum of the duration is incorrect.
Here is the data and the result:
Here are my formulas: