Bobby,
Works great, I knew it was something easy, I used excel in the Army and
became very proficient with it, so I knew the statement could be used, I just
could no remember all the variables.

Thanks again.

Jeff

"Bobby" wrote:

Jeff
If your formula works other wise, try:
=IF(AND(H100,A100),IF(H10A10,H10-A10-G10,H10-A10+24-G10),0)

HTH


"Jeff Thomas" wrote:

I am trying to use the if statement if excel, I have it working for the most
part, but it needs on more variable, and I am confused.

All numbers are times from a time clock so they are 24hr format with
hundreths.

=IF(H10A10,H10-A10-G10,H10-A10+24-G10)

the only problem is when H10 and A10 are blank, I get 24 as a result, I know
that is what I have told it to do, but I also want it to return zero if H10
and A10 are blank, or have 0's.