Ok I may have some difficulty in expressing this one, please bare with me....
We have team
leaders starting at specified times (8 hr shifts):
I want to calculate total staff coverage over the teamleader 8 hr shift.
there are ptime shifts of 6hrs and fultime staff 8hr shifts
The most simple example would be:
Team leader starts at 0700 and has
3 f/t staff starting at 0700 = 3
2 staff starting at 1300 = 4hrs (1300-1500 x 2 will cross team leaders 0700 - 1500 shift))
2 pt staff starting at 1100 = 8hrs (11-1500 x 2 will cross team leaders 0700 - 1500 shift)
so total for this day would be 4.5 staff crossing his shift. Attached is a sample of how i have set up the spread sheet minus
If you have a remote idea of what i am trying to express please check out and edit the spreadsheet
at will :-)
This question is more about how to calculate than anything I guess - thanks guys...