SOM not counting below 0 for overtime

[IIIdefconIII]

Hi there,

In my excelsheet i have on K225 a calculation of hours. =SOM(H225-I225-J225)
My workweek has 40:00 hours, as stated in G225. But if i have overtime so in I225 as example a value of 24:00 the time in K225 becomes ######.

Anyway to solve this or use it on another way?

Second Question is in L225 i like to have something like =SOM(I225*75), but its not giving my back te result

[AliGW]

Excel will not calculate a negative time. Where in the worksheet is the offending formula?

Here's what I see:

Excel 2016 (Windows) 32 bit

	E	F	G	H	I	J	K
224	Klant	Totaal		Totaal	Klanten	Systrax	Niet ingevuld
225	BUA	0:20		40:00	13:20	22:40	4:00

Sheet: Blad1

[IIIdefconIII]

Its ok now, but if you change I225 to a higher total it gets messed up

So H255-I255-J255 = K255. This 4:00 is the time that isnt filled in:
Which we then see in:

2018-07-20_16-38-04.png

[AliGW]

As I said, Excel can't handle negative results in time calculations. You will have to find a different way of dealing with this.

[IIIdefconIII]

Do you know any? I googled myself but couldnt find much,

I copied the H3 som to H255, so when the work hours increase, the sum increases as well. but then i also get #####

[AliGW]

Maybe your search terms were a bit off: https://www.google.co.uk/search?sour....0.x3c_zEbFJes