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