Hi all,
I am trying to do a planning schedule, which includes different earnings, such as; sick days, holiday earned, lieue days earned/taken, compensation earned/taken. The hoiday earned, and sick days were very simple because all I did was color code "H" for Holiday, and to the very right had a column in which it counted the "H"for holidays so that we know how many remains.
I encountered the problem when I need to sum hours earned in different ways, such as Lieue Hours, and Compensation Hours.
LE+amount of hours = LE1.25, and so on. LE = Lieue Earned.
LT+amount of hours = LT1.25, and so on. LT = Lieue Taken.
CT+amount of hours = CT1.25, and so on. CT = Compensation Taken.
CE+Amount of hours = CE1.25, and so on. CE = Compensation Earned.
<tbody>
</tbody>
I have scowered the net but unable to find anything that helps. I tried the sum if right / left code but didnt get it to work..
Please, if anyone has tips for me?
I am trying to do a planning schedule, which includes different earnings, such as; sick days, holiday earned, lieue days earned/taken, compensation earned/taken. The hoiday earned, and sick days were very simple because all I did was color code "H" for Holiday, and to the very right had a column in which it counted the "H"for holidays so that we know how many remains.
I encountered the problem when I need to sum hours earned in different ways, such as Lieue Hours, and Compensation Hours.
LE+amount of hours = LE1.25, and so on. LE = Lieue Earned.
LT+amount of hours = LT1.25, and so on. LT = Lieue Taken.
CT+amount of hours = CT1.25, and so on. CT = Compensation Taken.
CE+Amount of hours = CE1.25, and so on. CE = Compensation Earned.
Name | 1 May | 2 May | 3 May | 4 May | 5 May | 6 May | 7 May | Lieue Earned | Lieue Taken | Comp. Earned | Comp. Taken |
Peter | CE2.25 | CT1.25 | LE4.25 | LT3.25 | 4.25 | 3.25 | 2.25 | 1.25 | |||
Pan | CE1.25 | CT1 | LE4 | LT4 | 4 | 4 | 1.25 | 1 | |||
Rose | CE1.5 | CT1.5 | LE5 | LT4 | 5 | 4 | 1.5 | 1.5 | |||
Bert | CE1.25 | CT0.5 | LE5 | LT5 | 1.25 | 0.5 | LE5 | LT5 |
<tbody>
</tbody>
I have scowered the net but unable to find anything that helps. I tried the sum if right / left code but didnt get it to work..
Please, if anyone has tips for me?