Is the additional payment only for the hours worked between midnight and 4am or for the whole shift?

If the worker only crosses into this 4 hours period for say half an hour, at either end, does the whole shift accrue the extra payment?

Also, are you looking at a one off extra payment if the shift crosses into this 4 hour period or an additional hourly amount?

Sorry for all the additional questions but the original post was a little vague on details.

Hi Spencer,

Not a problem at all.

The additional payment is for the whole shift as long as a individual has covered 12-4am. So for example, if they worked 8pm - 4am, they would receive an extra £1.50 per hour for 8 hours.

If the individual only works couple of hours within that window, they would not receive a payment. They must have worked 12-4. If they work 8pm - 12.30am, they would not receive any night shift allowance. Even if they work, say 11pm-7am, because they 4 hour window is being worked, they would get night shift allowance for the whole 8 hours.

I hope this helps but please let me know if you require any more.

Thanks

Hi Prets

Have a look at the attached file. if I understand you correctly, as long as their shift includes the 4hrs 00:00-04:00, they get the night shift rate!

So in column G of the attached sheet is a IF function returning "Extra Payment" if they worked those hours, using the small table in L1:N3.
I have also included a column for payment using a nominal hr/rate (J2).

You might have to adjust the formula, as I might have misunderstood your post. I have paid them the shift plus an extra 4 hrs at £1.50 ph. This can be adjusted in the formula to pay an extra 1.5 for each hour if required.

Hopefully this is of some use!

Hi Kevin,

Thats brilliant. I cant actually express how helpful that is. I had to tweek it a little so the additional £1.50 is paid for all the hours but that wasn't difficult.

Again, thank you so much.

Pri

Hi Prets

No problem, glad I could be of some assistance and thank you for the feed back.

Kevin