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

hi,

can you describe or show the data disposition ?

--
isabelle


Le 2011-07-20 06:36, OM a écrit :
> 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

On Jul 21, 12:32*am, CWatters
<colin.watt...@NOturnersoakSPAM.plus.net> wrote:
> On 20/07/2011 11:36, OM wrote:
>
> > 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 ofconsecutivedays worked,
> > greater than 6consecutivedays). 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.

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

OM

On Jul 20, 7:00*am, isabelle <i...@v.org> wrote:
> hi,
>
> can you describe or show the data disposition ?
>
> --
> isabelle
>
> Le 2011-07-20 06:36, OM a écrit :
>
>
>
>
>
>
>
> > 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 ofconsecutivedays worked,
> > greater than 6consecutivedays). The reason for this is to keep a
> > check on worker fatigue, and compliance with maximum working hours.
> > Thanks for any help
> > OM

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