symbol for between

Hi All,

simple question as I have a blank mind. What is the symbel for between.

ie =if(a1 is between 10-15,1,5)

sorry its so simple but my mind is a blank.

cheers
brent

If there is one, I'm not sure what it is. But this will accomplish what you are looking for:

=IF(AND(A1>=10,A1<=15),1,5)

Jason

I am trying to use this to remove time from a calculation.
For ex. my assembler builds a widget usually in 30 mins. He has a break time at exactly 9:50 until 10:00.
He records the following data.
START = 2/27/2015 9:36:00
END = 2/27/2015 10:17:10
This totals 41:10 of assembly.
I want to automatically remove the break time with a formula and say that this took only 31:10 because it crossed through the break period criteria.

I am building a massive formula for this. The break times are from 9:50 to 10:00. 11:30 to 12:00. 1:50 to 2:00. The formula is not doing something right? As it is coming out negative.
Here is the DATA
TIME ACTIVITY
2/27/2015 9:00 ASSEMBLY START
2/27/2015 9:15 ASSEMBLY COMPLETE
2/27/2015 9:18 ASSEMBLY START
2/27/2015 9:34 ASSEMBLY COMPLETE
2/27/2015 9:36 ASSEMBLY START
2/27/2015 10:17 ASSEMBLY COMPLETE
2/27/2015 10:18 ASSEMBLY START
2/27/2015 10:35 ASSEMBLY COMPLETE
2/27/2015 10:37 ASSEMBLY START
2/27/2015 11:05 ASSEMBLY COMPLETE
2/27/2015 11:10 ASSEMBLY START
2/27/2015 11:29 ASSEMBLY COMPLETE
2/27/2015 12:09 ASSEMBLY START
2/27/2015 12:18 ASSEMBLY COMPLETE
2/27/2015 12:20 ASSEMBLY START
2/27/2015 12:53 ASSEMBLY COMPLETE
2/27/2015 13:01 ASSEMBLY START
2/27/2015 13:17 ASSEMBLY COMPLETE

Here is the Formula
=IF(AND(LOOKUP(VALUE(REPLACE(A2,1,5,0)),{0,0.40972222222222,0.41666666666667},{0,1,2})=0,(LOOKUP(VALUE(REPLACE(A3,1,5,0)),{0,0.40972222222222,0.41666666666667},{0,1,2})=2)),VALUE(REPLACE(A2,1,5,0))-VALUE(REPLACE(A3,1,5,0))-0.00694444444,IF(AND(LOOKUP(VALUE(REPLACE(A2,1,5,0)),{0,0.4791666666667,0.5},{0,1,2})=0,(LOOKUP(VALUE(REPLACE(A3,1,5,0)),{0,0.4791666666667,0.5},{0,1,2})=2)),(VALUE(REPLACE(A2,1,5,0))-VALUE(REPLACE(A3,1,5,0))-0.0208333333333),IF(AND(LOOKUP(VALUE(REPLACE(A3,1,5,0)),{0,0.57638888888889,0.5833333333333},{0,1,2})=0,(LOOKUP(VALUE(REPLACE(A3,1,5,0)),{0,0.57638888888889,0.5833333333333},{0,1,2})=2)),VALUE(REPLACE(A2,1,5,0))-VALUE(REPLACE(A3,1,5,0))-0.00694444444,VALUE(REPLACE(A2,1,5,0))-VALUE(REPLACE(A3,1,5,0)))))

Hi

Here goes

A1 Date B1 Start C1 Finish D1 Duration E1 Actual
B2 down start times
C2 down finish times
D2 =C2-B2
E2 =IF(OR(AND(B2<=$L$3,C2>=$L$4),AND(B2<=$L$7,C2>=$L$8)),D2-$L$1,IF(AND(B2<=$L$5,C2>=$L$6),D2-$L$2,D2))
F1 =SUM(D:D) elapsed time
G1 =SUM(E:E) actual time
Copy D2 and E2 down to match your data columns

Break durations and times
L1 =TIME(0,10,0)
L2 =TIME(0,30,0)
L3 =TIME(9,50,0)
L4 =TIME(10,0,0)
L5 =TIME(11,30,0)
L6 =TIME(12,0,0)
L7 =TIME(13,50,0)
L8 =TIME(14,0,0)

HTH

Sorry about that.
I cannot figure out how to start a new thread.

Hi I need help.
I need to create a table that gives me "expired", "expire soon", and "6 months mark" for 1 year contracts. It also need to change to the colors (red - expired), (blue - 6 months mark) and (yellow - expire soon). I would really appreciate you help. Thank you.