the first part of your IF statement

=IF(AND(F8<"X",F8=""),C3-D8,IF(F8<"",C3-F8)

take the And(F8<"X",F8="") then only thing that satisfys that is if
F8="", so the F8<"X" is redundant

now that would give you

=IF(F8="",C3-D8,If(F8<"",C3-F8))

that pretty much boils down to
If(F8="",C3-D8,C3-F8)

Which boils down to

=C3-D8

Although you might have an operator missing between that and the next
statement, it isn't clear, so think you would be better of saying what is
entered in each of your cells and what rules you want to apply to arrive at
what.

--
Regards,
Tom Ogilvy



"Richard" wrote:

I wrote this function, the logics seem to ok, but there are too many logic,
as I the result I think I mess up the syntax. Can anyone correct for me?

the function is:
=IF(AND(F8<"X",F8=""),C3-D8,IF(F8<"",C3-F8)IF(AND(G8<"X",G8=""),C3-F8)*IF(G8<0,C3-G8)*IF(AND(H8<"X",H8=""),C3-G8,)IF(H8<"",C3-H8,0))

where C3 is a now() function with customed to time, and where D8 is the
beginning time for an employee. The function above time elapsed from the 1
break to 3 break. Each time a break is entered now() function or C3 has to
minus the time starting a break, then this equal to time elapsed since last
break..thanks