Calculating time

[noodles1984]

Hi guys, I'm brand new to this site and i joined because i need help from the experts.

I just started a new job and i've been tasked with creating a new way of viewing the Shift rota so that it becomes obvious where our unmanned areas are.

The problem i'm having is the night shifts effectively start on one day but finish on the next. I only need to count this as one shift not two.If you like i can email the worksheet to any helpers to illustrate my problem.

Any comments or feedback would be brilliant.

Cheers

Noodles1984