Y
Yogin
Hi,
i have set up a spreasheet which gives me total headcount available by
regime and then convert each regime in hours.
EG. NL = Nights Loading staff, N = Nights Pick Staff, NG = Nights Goods in
Staff, NHOL = Holiday and so on..
I then carry out a countif sum to give me total available by day for each
regime. And on another worksheet I convert this into hours. I give each
regime a value.
EG. NL = 8hrs Loading, N = 8 Hrs Picking and so on.
If everyone worked an 8 hour shift this works fine but on occasions people
book 2 or 4 hours holiday or leave work early, but problem i am having is
that when I input the code NHOL4, this takes full 8 hours off from for
example NL (total hours) and not 4 as this person has worked and put the
other 4 hours into Holiday.
Can someone help me with this as I have done everything to correct this and
cannot find a solution.
Thanks
Yogin
i have set up a spreasheet which gives me total headcount available by
regime and then convert each regime in hours.
EG. NL = Nights Loading staff, N = Nights Pick Staff, NG = Nights Goods in
Staff, NHOL = Holiday and so on..
I then carry out a countif sum to give me total available by day for each
regime. And on another worksheet I convert this into hours. I give each
regime a value.
EG. NL = 8hrs Loading, N = 8 Hrs Picking and so on.
If everyone worked an 8 hour shift this works fine but on occasions people
book 2 or 4 hours holiday or leave work early, but problem i am having is
that when I input the code NHOL4, this takes full 8 hours off from for
example NL (total hours) and not 4 as this person has worked and put the
other 4 hours into Holiday.
Can someone help me with this as I have done everything to correct this and
cannot find a solution.
Thanks
Yogin