Cells not adding up correctly

[Geek Girl 007]

I have created this timesheet so that only certain cells will show when they are full etc.
However to total 'excess hours' is not adding up correctly 18:2, is what I make the total as in week 4 there was no excess.....
I don't know why I can't get this to work
I tried to post a XL2BB version into this post but even that wouldn't work for me

 

[Geek Girl 007]

I'm a little confused, I need it to be formatted as time because that's what I'm recording..... does that mean I can't fix it?

 

[Geek Girl 007]

Does that mean I can't fix it?

so basically I tried to do the same sum by equals the previous cell: F = E
But the sum still doesn't work.

 

[Fluff]

There is nothing to fix, Excel is working correctly. If you are not getting the answer you want, you will need to change one (or more) of your formulae.

 

[Geek Girl 007]

Ok, thank you

 

[jtakw]

Hi,

What exactly is in E53, some Text, or that negative value you mentioned above ?

 

[Geek Girl 007]

Hi Jtakw,
It's a formula for these cells.
=I53+J53+L53-M7........

 

[jtakw]

I saw that in your previous post, so E53 is a negative number, which indicates No Excess ?
And the Only value in E53 is a negative number, is that correct ?

 

[jtakw]

Try your SUM formula this way, if Any one or more of the 4 cells is negative (meaning No Excess), it'll be treated as 0 (zero):

=SUM(MAX(E20,0),MAX(E31,0),MAX(E42,0),MAX(E53,0))

 

[Geek Girl 007]

Hi Jtakw,
You are AWESOME, i think that worked...
I'll do a test run and let you know, but it's looking good so far

 

[jtakw]

You're welcome, hope it works for you.