I'm trying to calculate the net working minutes from a raw data that provids transactions with start and end time in the following format: 16/07/2021 9:23:00 AM and that would be all in one cell only.

The issue is that, there are concurrent transactions, which means (for example) we will have one that started 9:23:00 AM and ended at 9:45:00 AM, and another that started 9:32:00AM and endedat 9:58:00 AM.

If we consider every transaction alone to calculate the time we will get 22 mins for the first transaction and 26 mins for the second. But adding them is not right since they are overlapping, so the actual time spent should be 35 mins as net time spent in transactions.

Now I get hundreds of overlapping transactions and I can't seem to find a way to calculate the net time spent working on transactions per day.

Any help would be appreciated.

Thanks

Aladdin