Help with these formula...

[Tiffany]

Hi I need help determining the proper way to make this formula work in my
excel sheet: if h8<8 then i8=H8-8. I am trying to make a time card and I
need to put all hours worked over 8 in a seprate column. I would also like
to make it so the total in column H8 can not be greator than 8 so: if h8<8
then h8 = 8. That way h8 + i8 would be the total hours worked by my
employee. Thanks!!!

 

[Pete_UK]

I think you meant:

.... if h8>8 then i8=H8-8 ...

One way is to put this formula in I8:

=IF(H8>8,H8-8,0)

An alternative is:

=MAX(H8-8,0)

This takes the larger of the two values, so if H8 is less than 8 then
0 will be taken as H8-8 will be negative. If H8 is greater than 8 then
H8-8 will be greater than 0, so this value will be taken.

You cannot put a formula in H8 which affects the value of H8 - you
will have to put it in some other cell (eg J8). A formula similar to
my second one would be:

=MIN(H8,8)

so if H8 is less than 8 its value will be taken. If it is above 8 then
8 will be taken.

Hope this helps.

Pete