Nothing is really going wrong with what i am doing because i literally have to enter all the data manually, i am hoping someone can suggest a formula which will calculate everything automatically.
Please see attached sample spread sheet. Tab 2 is the detailed breakdown (this is how i am currently doing it) based off the individuals start date and rotation i go in an manually figure out which days the person will be working and adding the hours to that day, from there i can simply figure out how many hours they work in a week. The issue with this is there is about 200 employees whose rotation, hours worked, and start or end dates constantly adjust/change, so it becomes alot of work every month. If there is a formula that could do the calculations for me (based of the changes in make to rotation, hours, or start and end dates) it would simplify my life alot. At the end of the day i want to just go in and change (say Adam for example) work days to 12 and non-work days to 9 and his end date to 10-11-16 and have the hours worked detailed table update itself, rather then having to go in and manually update everything.
I have also included a second tab called summary; if there is a formula to figure out the hours work just as a summary per month, that would also work.
Thanks
|