Hi Guys
I have a the table below which I am trying to work backwards to remove a leave balance essentially I want to deduct LSL hours (45) from the hours column working backwards so once 0 is reached in moves to the next row and deducts from that, in this case we would still be at +5 because the LSL hours taken are 45 and the balance is 50 but in the cicumstance where LSL taken was 60 then it would need to minus the 50 display 0 then move to detract the remaining amout from the following row. Is that possible?
<tbody>
</tbody>
I have a the table below which I am trying to work backwards to remove a leave balance essentially I want to deduct LSL hours (45) from the hours column working backwards so once 0 is reached in moves to the next row and deducts from that, in this case we would still be at +5 because the LSL hours taken are 45 and the balance is 50 but in the cicumstance where LSL taken was 60 then it would need to minus the 50 display 0 then move to detract the remaining amout from the following row. Is that possible?
LSL Taken | 45.00 | ||
Total Days Between Start and End | 8674 | ||
Range | Days | Percentage | Hours |
Pre 16/08/78 | 0.00% | ||
16/08/78 – 17/08/93 | 940 | 10.84% | 5.4185 |
Post 17/08/93 | 7734 | 89.16% | 44.5815 |
8674 | 100.00% | 50.0000 |
<tbody>
</tbody>