Need help in nested formula

[gerard_gonzales33]

Hi everyone!

Can somebody or anybody out there help me check my formula, if it's correct? But first how or does the forum allows to type directly the excel formula here? my attachment will be my excel formula.

Thanks

[martindwilson]

no attachment
to attach
edit your post and click "go advanced"
then from the tool bar above the edit window
click the paperclip icon
in the new window click "choose file"
browse to your sample
double click it
then click upload
then click "close this window"
now back to edit window and click "save changes"

[JBeaucaire]

Include all the pertinent information in the post. If you have questions about the forum rules, use the Forum Rules link above to review them.

[gerard_gonzales33]

my apologies.

[gerard_gonzales33]

Guess i rather attached my file and indicate my queries regarding the correctness of my formula.

Here's my queries I have this formula to compute for the total tardiness and under time (column K and L respectively. The contents of this formula are as follows:
1. It has a fixed working hour, then subtract it to column D for tardiness,
2. While on column L it subtracts column E.
Both column K and L recognizes the Saturdays and Sundays as non-working day- so tardiness and under time is not applicable.
3. Also column K and L must subtract either of these columns : G;H and I. So that if there is data encoded it shall subtract the column D and or column E;either of the three columns G; H and I.
One thing that also drives me crazy. How can I trigger the column K and or L to recognize the data that was encoded (regardless it's AM or PM)? I have tried but the column L was affected.Kindly see my attached my sample file.

I hope someone, anyone could help me regarding my queries and I hope my post is clear enough.

Thank you in advance.