Hi guys, hoping for a bit of help here regarding formulas. I don't expect the full formula to be written out, but just some rough guidelines and to how you think I should go about sorting this issue.
I am composing a spreadsheet which I am tracking the hours in which workers have worked. As a part of the law in this country, there are some rules which we need to follow and the purpose of this spreadsheet is to record and monitor these rules.
If you view this image (https://imgur.com/5yAJ4vH) this shows you how I am sorting the data. The data in inserted via a User Form. However, I need a way of monitoring if the following is true:
My plan at the moment, is to use pivot tables to find certain data, and then via the use of GETPIVOTDATA, insert that into a dashboard sheet. However, I am not sure how to go about monitoring the bullet points above.
If anyone has any ideas on how to approach this, I would greatly appreciate it!
Sorry if this doesn't make sense, more than happy to clarify what I mean by this.
I am composing a spreadsheet which I am tracking the hours in which workers have worked. As a part of the law in this country, there are some rules which we need to follow and the purpose of this spreadsheet is to record and monitor these rules.
If you view this image (https://imgur.com/5yAJ4vH) this shows you how I am sorting the data. The data in inserted via a User Form. However, I need a way of monitoring if the following is true:
- No more than 72 hours worked in one week
- No less than a 12 hour break between shifts
- A maximum of 6 days worked consecutively.
My plan at the moment, is to use pivot tables to find certain data, and then via the use of GETPIVOTDATA, insert that into a dashboard sheet. However, I am not sure how to go about monitoring the bullet points above.
If anyone has any ideas on how to approach this, I would greatly appreciate it!
Sorry if this doesn't make sense, more than happy to clarify what I mean by this.
