Excell spreadsheet

[gbat228836]

If I work 11hrs how do I move hrs above 8 to the next cell and any hrs over 2 to a third cell?

[#2]

@gbat228836

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)