Hi,

Suppose they work 5.25 hours what do you give them for a lunch break 1/2
hour, 1/4 hour or something else? If they work an 8.5 hour shift do you
count 8.5 hours of work and 1/2 hour lunch or 8 hours work and 1/2 hour work?
If they complete an 8 hour shift at 6PM but haven't taken lunch do you
consider the lunch (6:00-6:30 PM) as night shift?


--
Thanks,
Shane Devenshire


"Sara" wrote:

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?