Name | Org | Day | Start | End | Minutes | Incorrect |
Person 1 | A | Monday | 5:05 pm | 6:00 pm | 0:55 | 0:25 |
Person 2 | B | Tuesday | 5:05 pm | 5:15 pm | 0:10 | 0:10 |
Person 3 | C | Saturday | 6:15 am | 2:50 pm | 8:35 | 0:00 |
<tbody>
</tbody>
Hello all,
Hoping someone can provide some assistance with creating an excel formula.
I have a whole heap of data of when people have worked overtime but I know some is incorrect and I need to capture those incorrect entries.
Basic rule is cannot work overtime between 5:30 am and 5:30 pm from Monday to Friday.
So, from the data above, Person 1 claimed 55 minutes of overtime but 25 was incorrect (between 5:30 and 5:30), person 2 claimed 10 minutes which was all incorrect, Person 3's was on Saturday so theirs is fine.
I need a formula that will calculate the incorrect minutes.
Thanks in advance for any assistance.