By subtracting this number by 8, I get the my +- flex earned that day.
First, I wish to display the cumulative sum for the total flextime account, corresponding to every working day, i.e.:
A B C 1 Time Flex Cumulative Flex 2 8.25 0.25 0.25 3 8.5 0.5 0.75 4 7.75 -0.25 0.5
Second, I want the plot it, having some kind of date reference on the horizontal axis, e.g. day of the month.
P.s. I tried making an ArrayFormula as e.g. C3
=ArrayFormula(B3:B100-8+C2:C99) but got:
error: Circular dependency detected