Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dificulty adding alphanumeric values either one letter or two
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing text from Alphanumeric values | Excel Worksheet Functions | |||
Adding Dashes to a 25 digit alphanumeric cell | Excel Discussion (Misc queries) | |||
Dificulty in copy and paste when items is filtered in excel 2007 | Excel Worksheet Functions | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
how do i enter alphanumeric values? | Excel Discussion (Misc queries) |