Hi, I have a sheet which records the days worked and hours clocked in/out. I have spent a couple of days trying to work this out ... without success.
People clock in/out at random times during the day/night and are paid day rate between 05:00 - 17:00. After that they are paid night rate.
After 8 hours in any one shift they are paid overtime.
After 6 worked hours they are deducted 45 minutes break but this is not deducted until the end of the shift which could be days or night rate.
I need to calculate how many day hours, how many night hours and how many day/night overtime hours they have worked (less breaks) and Saturday/Sunday hours are all at either day or night overtime rates.
I have added the rules in a textbox on the attachment - would really appreciate some help with this before I go mad.
Thank you
Bookmarks