Good evening everyone, I hope you can help me.
I'm trying to divide colleagues' working times into hours in order to calculate productivity. I've managed it for the early shift and the late shift, but I can't do it for the night shift (day change). Attached is an example table. I would be very happy if you could help. Many thanks in advance.

Greetings
Charlie

Attached Files

Beispiel.xlsx (10.2 KB, 9 views)