Add time sheet hours

[AAFox]

I am trying to add the hours up, and once block I16 hits 40 hours would like the remaining hours to populate in block I17. 

The formula that I used to get total hours per each day: =if(g6>h6,h6+1,h6)-g6

The formula that I used to get total hours in block I16: =sum(I6:I15

[#2]

@AAFox 

A shorter formula in I6:

=MOD(H6-G6, 1)

Edited to correct mistakes!

In I16:

=MIN(SUM(I6:I15), 40/24)

In  I17:

=MAX(SUM(I6:I15)-40/24, 0)

[#3]

I was unable to get these formulas to work.

[#4 · Accepted solution]

@AAFox 

I have corrected my previous reply.

I have attached a simple sample workbook to this reply.

[#5]

Thank you, it worked perfectly.