Multipul equations resulting in 1 answer?

Hi all,

Recently I asked the question below:

https://ccm.net/forum/affich-348337-value-error-when-sourcing-data-from

That solved the problem I was having, however, created a new one that I hadn't considered before :(

The aim of the sum above was to establish the amount of hours accumulated per week 'over' 8 hours.

So the equation is subtracting 32 hours from a 4 day period (as Fridays there is no overtime permitted), (8x4).

The new problem is that I would like the overtime to be shown per day in the sum cell, rather than just the total per week.

So if I did 9,9,10,8 hours in the first week, that would be 4 hours overtime.

At the moment, if I just enter 9 on the first day (Monday), the responding cell remains 0. It remains 0 up until I have added the 4th day. This is because I am subtracting 32 over the week, rather than just subtracting 8 per day IF more than 8 hours have been done.

How can I illustrate this into the equation so that the responding cell calculates the overtime per day? And then establishes the total for the week in the same cell?

Here is the link to Edit Grid:

http://www.editgrid.com/explore/user/klis-test/TT_Error_Test


Please provide the formula here, should someone change something :P

The formulas are the same as in the first question, with exception to the revision from the previous answer, which is now:

H4: =sumif(F3:F4,"<>",F3:F4)

Please advise and thank you very much in advance! :D

Klis