Hi there,

I have a spreadsheet to calculate shift hours with each day of the week
stating start and finish times.
A1 = Sun Start, B1 = Sun Finish, C1 = Mon Start, D1 = Mon Finish etc
I'm trying to calculate the total number of nightrate hours for a week (to 2
decimals points) worked between 8pm & 6am.
This formula also needs to subtract the lunchbreak of 1/2 hour after 5 hours
work.
Shifts range from 4 hours to 8.5 hours per day and not all shifts go into
the nightrate period.

Any ideas?