Hi Guys, I am trying to get a formula going which will show if an employee has worked over 6 consecutive days. The way in which my data is currently stored is like the following:
<tbody>
</tbody>
I would like in another sheet to show if any employee has worked over 6 consecutive days within a week. Please note that the data may not always be inputted in chronological order or with the employees days being sorted together.
Does anyone have a way in which to do this?
Kind Regards
DATE | Week | Employee | Hours Worked |
01/05/18 | 18 | Bill | 10:00 |
02/05/18 | 18 | Bill | 14:00 |
03/05/18 | 18 | Bill | 08:00 |
01/05/18 | 18 | Phil | 10:00 |
02/05/18 | 18 | Phil | 10:00 |
03/05/18 | 18 | Phil | 10:00 |
04/05/18 | 18 | Phil | 10:00 |
05/05/18 | 18 | Phil | 10:00 |
<tbody>
</tbody>
I would like in another sheet to show if any employee has worked over 6 consecutive days within a week. Please note that the data may not always be inputted in chronological order or with the employees days being sorted together.
Does anyone have a way in which to do this?
Kind Regards