calculation help needed

[Greg (codepug]

A company has 4-shifts (ie 1,2,3,4) and each shift is 1-day (24hrs),
and the shifts repeat after
they complete. Shift 1 to 4 is Monday to Thursday, so the following
Shift 1 to 4 is Friday to Monday and this continues on a 4-day cycle.

If an employee works only on shift2, how do you calculate the number
of days
from shift3 until his scheduled shift2.

Thanks Greg

[Salad]

Greg (co*****@gmail.com) wrote:

A company has 4-shifts (ie 1,2,3,4) and each shift is 1-day (24hrs),
and the shifts repeat after
they complete. Shift 1 to 4 is Monday to Thursday, so the following
Shift 1 to 4 is Friday to Monday and this continues on a 4-day cycle.

If an employee works only on shift2, how do you calculate the number
of days
from shift3 until his scheduled shift2.

Thanks Greg

Add 4 days from a shift 2 date?

I would start with a "initialize" date that is Shift 1. From that date
you can get the number of days between two dates. Then use Mod to see
which shift it is.

[Greg (codepug]

Thanks Salad, I wasn't sure how to build the equation using the Mod
operator
but this worked.

The formula from the Math Group guys. Thanks.

let n = number of days, c = current shift, w = working shift. Then
n = (w - c + 4) % 4;
where % is the modulus operator.

Alternatively, using the C language's ? operator:
n = (w - c >= 0 ? w - c : w - c + 4);

Dave

Greg