- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Calculation Help Needed

Subject: | Calculation Help Needed |

Posted by: | Greg (codepâ€¦@gmail.com) (codep…@gmail.com) |

Date: | Sat, 26 Jul 2008 |

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

- Re: Calculation Help Needed posted by TheHeatons on Sat, 26 Jul 2008