Time Duration overlaps

[Aether03]

Hello Everyone,

I'm looking for a method/formula to solve time duration overlaps. Check the example below,

Person A has a 47 minutes activity on 10/21/2021. However, in reality; Person A had 31 Minutes activity on the 21st, and 16 minutes on the 20th (total 47), alongside another 15 minutes on the 20th, but it was registered on the 20th.

So long story short; it's a 24 hours shift that starts on the 21st and ends on the 22nd, and for some reason; the raw data extracted overlaps such activities because of the 24 hours period.

I've been looking for a method to solve such an issue for so long, but unlucky you know.

Edit: This is how it looks like in the pivot table

PixDVU6.png

[Pepe Le Mokko]

Hi
there are instructions at the top of the page on how to post a sample sheet

[Aether03]

Here you go. Added!

[Pepe Le Mokko]

Is this what you are looking for ( col I yellow background)