J
JC-PS
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 AB
at the moment like examples. Any doble letter or single letter without
numbers beside them are equivalent to 7.5 as their values.
Monday….Tuesday.Wenday
----
2….C ....... D… ….F… …. J........K...........Z....AA....AB
----
3… - ........LE…. W ..... SE3.....S…........7,5…7.5...3
----…
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.
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 AB
at the moment like examples. Any doble letter or single letter without
numbers beside them are equivalent to 7.5 as their values.
Monday….Tuesday.Wenday
----
2….C ....... D… ….F… …. J........K...........Z....AA....AB
----
3… - ........LE…. W ..... SE3.....S…........7,5…7.5...3
----…
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.