hi, (...) ???

if you don't get a *clear* proposal to your post in a reasonably short period of time, try the following:
- back to the spanish news-group
- answer the questions about the holes in your post

regards,
hector.

__ OP __
"JC-PS" escribió en el mensaje ...
I have a rank of C2 to N2 of which C2 to G2 will represent the days of first
week of the biweekly. Between means of column G and J it represents Saturdays
and Sundays, in H and I respectively. Of the J to the N it is 2nd week of the
biweekly. If the employee in this case, for Tuesday needed all the day, or it
is, D3 cell and that is recorded on his archives of that employee, a single L
is reflected which is equivalent to his labor day of 7.5 hours. But it is
absented without reason Thursday and in this particular situation would apply
a W here (it implies without payment) that is, cell (F3) and in next week
Monday at afternoon retires of their work area (J3) by just disease (SE) 3
hours before the official exit, is described in the table of cumulative
absences an SE3. But on the other day, it absents without giving excuses
certified by a doctor by disease (S). To the end of this line 3, column Z,
must add the S in this case, which could have been with L that is using his
cumulative vacations or LE if they are officially authorized or programmed.
The formula asked must well apply for that line 3 and in the other column
alongside, to say column Z to add the S. On equal results with the LE and SE
should leave total-sum of that biweekly in other separate columns, AA and BB
at the moment like examples.

Monday€¦.Tuesday.Wenday
----
2€¦.C ....... D€¦ €¦.F€¦ €¦. J........K...........Z....AA....BB
----

3€¦ - ........LE€¦. W ....... SE3 .....S€¦. ........3....7,5€¦7.5
----€¦

The idea is to leave totals in different columns for the same biweekly as
much for the L, LE, SE, S, and W (or could be others letters identifying
other kinds of absences like O, F, CL etc) but that when they apply to an
absence of complete day where it does not detail the 7.5hrs of days
accompanied by the letter or letters (in pair) but only when it is several
hours or he leaves part of an hour. Should be clarify in case otherwise on
line 3 there were LE3.5 and L with other letter(s) like SE or/and S for other
days of the week or 2nd week, with other same bare letter in different days
like LE should end up adding 3.5 + 7.5 = 11 on a final balance column for LE.
So the formula must be used on those final columns either for one or another
letter or letters with or without numbers beside them and copy through all
the year(s).
I'll appreciate any help.