View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Excel Calculation problem

I still would like to see an example layout of some data. If you change the
NL to NHOL4, how do you know that the other 4 hours would be NL, and not NG?
Are there multiple codes possibly entered for a person? i.e.: NL, NHOL4.

Further clarification, if someone has 4 hours of Loading, and 4 hours of
holiday, what code do you enter. If you enter just NHOL4, how would excel
know that the other 4 hours are NL, and not NG.

--
John C


"Yogin" wrote:

Hi John,

Thank you for replying back so soon.

Eg. I have someone who is planned planned to work on nights Loading (NL)
this equeates to 8 hours, but during the shift I have authroised 4 hours
holiday, so what I do is I change NL to NHOL$ (4 hours). In my countif some
this takes away full 8 hours from Nights Loading and then transferring 4
hours into NHOL4. What should happening is instead of taking the full 8
hours, in the NL regime I was looking for a formula to take into
consideration that this person has worked 4 hours and the remaining 4 hours
are as holiday. So NL = should equal to 4 hours instead of 0.

I hope this make sense if not I can email you an example of the spreadsheet
i'm working on.

Thanks

Yogin

"John C" wrote:

Can you give more specific examples? You talk about code of NHOL, but then
refer to NHOL4 later on. If someone isn't using all 8 hours for a specific
code, are you then tacking on how many hours that code is using?
--
John C


"Yogin" wrote:

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