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
|