Multiple Function

[japturtle]

I have a working function and need to add another to it if possible, please help!

Current Function:

=IF(OR(C4=C3, C4=C5),"","no lunch")

I want to add:

If H4 is greater than or equal to 6

 

[villy]

Try:
=IF(AND(OR(C4=C3, C4=C5),H4>=6),"","no lunch")

 

[japturtle]

Thanks for the reply, but it didn't work... Here are more details if it helps!

<TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=64>



</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 width=64 align=right x:num="40280">4/12/2010</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl25 width=64 align=right x:num="0.47916666666666669">11:30</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl25 width=64 align=right x:num="0.67708333333333337">16:15</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl25 width=64 x:str=""></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BACKGROUND: red; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-ignore: style; mso-pattern: auto none" width=64>no lunch</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl25 width=64 align=right x:num="0.19791666666666669" x:fmla="=D1-C1">4:45</TD></TR></TBODY></TABLE>

Column C4= 4/12/2010
Column D4= 11:30
Column E4= 16:15
Column G4= No lunch (in red)
Column H4= 4:45

I don't want anything in G4 if H4 is less than or equal to 6

 

[exAHSacto]

Well thats a bit different from the first question.

try this formula: IF(H4<=TIME(6,0,0),"","no lunch")

/Anders

 

[japturtle]

Thanks exAHSacto! It worked... I realized I did say the complete opposite on my first post but figured I could switch the symbol around ... thanks again!

I have another function I need to figure out, here goes...

If:

A B C D
4/1/11 10:00 12:00
4/1/11 13:00 18:00 8 hrs
4/2/11 10:00 14:00 4 hrs
4/3/11 10:00 12:30
4/3/11 13:00 17:30 7.5 hrs

How do I create a function to get the answers listed above in Column D?? Where Column D is the value of the start and stop times in one day?

 

[exAHSacto]

No problem.

Please explain "the answers" in column D

 

[japturtle]

The answer in column D2 is the result of C2-B1.

I currently have it as:

=C2-B1

But this causes D column to have the following answers:

2 hrs
8 hrs
4 hrs
2.5 hrs
7.5 hrs

I only want one daily total... not per shift total.