I am putting togethor a worksheet to keep track of costings through the
week. This part is for wages, and staff are paid at 2 rates. Rate 1 (R1) is
from 06:00 to 22:00, and Rate 2 (R2) is from 22:00 to 06:00. I am trying to
automate the hours worked on various shifts so that when I am building a
rosta, it automatically works out the hours worked at the different rates. I
need to keep track of R1 and R2 hours worked on each shift through out the
week (Mon - Sun). ie someone might start work at 21:30 and work through to
07:30, someone else might work 22:30 to 05:30 and someone else 09:00 to
19:00. I have got the general formula, but I cannot get it to work if
someone finishes a night shift before 06:00. C17 is the start time, E17 is
the finish time with F17 listing the total hours worked, G17 listing break to
be deducted and R1 total in H17, R2 total in I17

I would be grateful of any suggestions made. Thanks for your help