Ok here is another solution with details ........ now u can put any date in column C2 and result will be shown in C3 ....... but keep in mind that A1 value must be less then A2 ..........
A1= 9:00 AM
A2= 4:00 PM C2=08:59 AM
C3=IF(AND(C2>=VALUE(A1),C2<=VALUE(A2)),"TRUE","FALSE")
IF(AND(A1>=0.375,A2<=0.1875),"TRUE","FALSE")
Y did u use these 2 Bold values instead i would have write it simple time , and if u did how did u get this value
secondly , Please Advice the function of "AND" in excel
Thirdly , i m using EXCEL 2007 , where to put this formula
=$D2="Partial" What does this formula mean
can you please elaborate
Please Upload the excel for both the above example and provide me the link so that i can get an idea
PERHAPS A VERY SIMPLE EXAMPLE WITH "AND" FUNCTION WILL BE EASY TO UNDERSTAND .
I TRIED THIS HIGHLIGHT FUNCTION IT DIDNT WORK :(