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]

Looks like it is so far, just sent a 'tester' out.... I think you're brill.
Thank you so much

 

[Geek Girl 007]

Sorry, one last question....SEE BELOW (my staff, always the critics haha)

If I am meant to put this into a new thread.... please let me know, (I have no idea why I can't work this out)

 

[jtakw]

What do you mean by "look different" ?

Do you mean CF ?

 

[Geek Girl 007]

Hi jtakw,
I want it to be a different colour, I have some of my staff on toil reduction and when they go over their hours I want them to see it so they can manage it themselves.....

 

[jtakw]

CF for H62

Book3.xlsx
	H	I
61	148:00:00
62	151:00:00
Sheet1061

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H62:I62	Expression	=H62>H61	text	NO

 

[Geek Girl 007]

Thank you, I will defo give it a go

 

[Geek Girl 007]

CF for H62

Book3.xlsx
	H	I
61	148:00:00
62	151:00:00
Sheet1061

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H62:I62	Expression	=H62>H61	text	NO

Hi again,
I've been trying with this but it doesn't seem to want to work.
What am I doing wrong please..... ?

 

[Geek Girl 007]

Hi again,
I've been trying with this but it doesn't seem to want to work.
What am I doing wrong please..... ?

View attachment 60899

I realised I was asking the wrong question, so sorry.
I fixed it. Thank you.

 

[jtakw]

Glad you sorted it out.