Counting consecutive cells

  • Thread starter Thread starter OM
  • Start date Start date
O

OM

I have a spreadsheet of hours worked per day, for employees. I need to
have an easy way (a function would be great), that can tell me if any
worker has worked more than 6 days in a row.
If an employee only works Mon - Fri, them there would be a value of 0.
If an employee worked 5 days, Sat and Sun, and then another 5 days,
the function would return 12 (the count of consecutive days worked,
greater than 6 consecutive days). The reason for this is to keep a
check on worker fatigue, and compliance with maximum working hours.
Thanks for any help
OM
 
Perhaps add a helper column (or row) in which each cell "looks" at the
previous 6 days worth of data. A simple IF statement should be able to
identify if none of the previous 6 days contains one with zero hours
worked.
Click to expand...

Thanks for that - it does seem to be the only way (other than using
VBA

OM
 
hi,

can you describe or show the data disposition ?
Click to expand...

The data is in columns, and just gives the Start Time for a day. If
there is a Start Time, then the person worked on that day. If they
didn't work the next day, the next value down would be blank.

Thanks OM
 
Back
Top