I have a table where the time is to be added for the week. This poses
no problem. But I have difficulty when there is a night shift. I have
given below an example

Start Finish Start Finish Start Finish Start Finish
Start Finish Start Finish Start Finish
Mon Tue Wed
Thurs Fri Sat Sun

Sup 1 09:00 17:00 09:00 17:00 09:00 17:00 09:00 17:00 09:00
17:00 off off
Sup 2 19:00 7:00 19:00 07:00 19:00 07:00 off
off off off

As can be seen from the above example, supervisor 1 works for 40 hours
a week, and supervisor 2 works for 36 hours a week.

I am looking for a single formula that will deduct 17:00-09:00 for each
day which will give a row total of 40 hours. But at the same time it
needs to be applied to the second supervisor who works the night shift
and completes at 7 am in the morning. This is creating difficulty as
the 07:00 is less than 19:00 the previous day.

Any ideas out there.