No, I have not painted myself into a corner. I simply have not thought it
necessary to bring up the other properties of the workbook, since they were
not relevant to the question.

I do not want all workdays on a single sheet, as in reality I am not merely
discussing "column C", each sheet is going to track 40 plus people, one
column per person. I want each sheet to be a snapshot of the entire day, so
any person can look at it and see, for instance, that 3 people were there at
2AM, all 40 people where working at 10AM, that 10 people were working at 7PM,
3 people at 11:30pm, etc. the reason I want those cells colored is to show
each persons presence or non-presence. I need 7 days to show the fluctuations
each day, and when certain people are going into overtime. At that point, I
want those cells to be red, not green.
I have no problem with working with multiple sheets, and carrying formulas
over.
This workbook is not for payroll purposes, and doesn't have to be that
exact, as evidenced by the fact I'm willing to account for time in broad 1/2
hour increments. My purpose is illustrative, using a broad brush. I am trying
to show others in a broad way when we have people working that would be
better utilized at another time.

Your proposal sound like it would work....however, I don't know the process
of assigning a serial number to a cell.

How would one "assign a serial number to each X"?

"HALinNY" wrote:



"carrera" wrote:

I find your response inappropriate and rude. Are you employed by Microsoft
Office Online, or are you another random person in the community?

To address your "questions"
Am I getting paid to do this?....I frankly don't know what you mean by that
question, and I don't see where it has any bearing on my question.

Reinventing the wheel, I did not know that is what I was doing. We have
an automated timekeeping system, I am trying to ascertain what times of the
day people are incuring the most overtime, and need a visual to show those
responsible for scheduling. However, again, I don't see where this has any
bearing on my question, and you are making assumptions regarding why I was
asking the question. I did not realize my question had to pass some kind of
litmus test for worthiness.

It is obvious I have done quite a bit of the work on my own, and I am
seeking this last puzzle piece. I have endevored to solve this, and have made
my best effort. That is why I have turned to this forum.

So, now that I have complied to your rude and unnecessary question, do you
or do you not know of a solution to my question?


My apologies. I was just trying to be avuncular and you misunderstood me.

So if I understand this correctly, you have a workbook where each sheet
covers one day and you accumulate Xs from the beginning of the work week,
day-by-day, to the end of the work week. A green X represents a half-hour of
regular time and a red X would indicate a half-hour of overtime. You use a
40-hour week and there is no time deducted for breaks or lunch.

What you need to do is attach a serial number to each X that you generate
based on the start and stop times. That is to say that each half-hour
increment that is accounted for is assigned a number and if the number is
below 81, the X is green; otherwise it is red.

My recommendation would be to put all workdays on a single sheet because it
makes counting the allocated increments much easier and less error-prone
because moving something around on one sheet could affect all the others in
ways you did not anticipate.

Then lay out the days and hours in a matrix that facilitates the counting of
preceding Xs which would give you the serial number you need to decide if the
X should be green or red.

I don't want to go any further at this point because I may have made an
incorrect assumption or you might not need any more help.

And to answer your other questions, I do not work for Microsoft. I am just
one of those people who have been using EXCEL for about 20 years now. And
when you say you are seeking the last puzzle piece, what you really mean is
that you have painted yourself into a corner. And your taking umbrage and
copping an attitude when someone tries to help you only proves that I am
right.

So please let me know if there is anything else I can do for you, :)

B+
HALinNY