Manage flexible schedules of 60 chauffeurs

[zirif42]

I have 60 chauffers. They work on a schedule of x days work and x days rest. I need detailed steps in exel to organize them. Column C chauffers. Column D etat actuel. Column H number of days worked per rotation i fill for every chauffer. Column I days of rest per rotation that fill for every chauffer. Column E that shows days worked in the current rotatio based on todays date and the value of column H. Column F that shows days rested based on todays date and the value of column I. Column G to enter the starting date of work that i enter for every chauffer. Give the answer and the steps in french and based on a french excel

 

[Rijnsent]

Hi Zirif, what you could start with:

• Questions in Other Languages - to post the question in French - most people here won't have a French Excel...
• Please use XL2BB - Excel Range to BBCode to show an example of what you're trying to achieve, preferably with some dummy data and formulas that you did make (that reads much easier than a story)