Forum Discussion
Excell spreadsheet
If I work 11hrs how do I move hrs above 8 to the next cell and any hrs over 2 to a third cell?
You can accumulate hours over a threshold using the MAX function. The first formula below returns any hours over 8, or 0 if there weren't any such hours. The second formula returns any hours over 2, or 0 if there weren't any such hours. These formulas assume that you are using whole numbers to represent the hours.
=MAX(B2-8,0) =MAX(B2-2,0)
If you are using times like 6:45 in cell B2, then the formulas would be slightly different:
=MAX(B2-8/24,0) =MAX(B2-2/24,0)