R
Richard
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
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